Browse by Tags

Installing Visual Studio 2008 and SQL Server 2005

If you are upgrading to Visual Studio 2008 then be careful with SQL Server. You may or may not know that the Business Intelligence Development Studio (BIDS) is a visual studio shell. If you don't have Visual Studio installed when you install SQL Server then it installs a version of Visual Studio for...

Posted to SimonS Blog on SQL Server Stuff (Weblog) by simonsabin on 12-04-2007
SSIS Pipeline - Katmai changes - Reusing data

Katmai increases the concurrency of SSIS packages by a change to the pipeline. In SQL 2005 a dataflow is split into sections, This is called the execution tree. Each section has the same buffer strucuture and the buffers are passed to each component in the section of the pipeline. A new secton starts...

Posted to SimonS Blog on SQL Server Stuff (Weblog) by simonsabin on 11-16-2007
What application doesn't have UNDO in today's world

Well the first that is close to my heart is Integration Services and its really annoying. I tried to track down a connect item for this but couldn't find a specific one. So I raised one https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=308794 . We've been told that undo didn...

Posted to SimonS Blog on SQL Server Stuff (Weblog) by simonsabin on 11-06-2007
SSIS - Change your GUIDs

Did you know that your package has an identifier in it? Well it does and it can be used to provide automated reporting of your package executions. Using the eventhandlers you can log information to a central store to provide easy reporting. The key for this to work is to use the identifier for the package...

Posted to SimonS Blog on SQL Server Stuff (Weblog) by simonsabin on 11-06-2007
SSIS - Maintenance Plan Tasks

In using SSIS you will have noticed a section in the toolbox labelled Maintenance Plan Tasks. You will have seen in there tasks like "Execute SQL Task". You may be tempted to use these in your package. DON'T These are tasks that are designed to be used in maintenance plans and not in normal packages...

Posted to SimonS Blog on SQL Server Stuff (Weblog) by simonsabin on 10-29-2007
SSIS - Class not registered (0x80040154) Excel Source

Just a quick note that if you are developing SSIS packages with Excel on a 64 bit machine you need to make sure the package is configured to not use 64bit runtime. There are no 64bit Excel drivers (Jet) and so whilst you code works in the desiger, i.e. getting fields and doing previews etc it won't work...

Posted to SimonS Blog on SQL Server Stuff (Weblog) by simonsabin on 10-25-2007
SSIS - Testing the source in your data flow

When building an SSIS package, which I seem to be doing more and more of lately, I am invariably using a data flow. Whilst the data flows often end up with complicated transforms in them my approach to building it is very much bit by bit. The first step is to get your source component working. To do...

Posted to SimonS Blog on SQL Server Stuff (Weblog) by simonsabin on 10-25-2007
SSIS change to pipeline for custom components

If you've written your own custom components then you should read this post on the SSIS forum about a possible change to the pipeline that may affect your component. http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=2190281&SiteID=1&mode=1 if ((typeof(socialButtons))!="undefined") { socialButtons...

Posted to SimonS Blog on SQL Server Stuff (Weblog) by simonsabin on 09-25-2007
SSIS Dates aren't very precise

I'm implementing some SSIS packages at the moment and started looking at logging with the event handlers. I simply wanted task start and end times etc and so used the start time system variables. What I noticed when I ran reports was that the accuracy of these values is to the second. When you've got...

Posted to SimonS Blog on SQL Server Stuff (Weblog) by simonsabin on 09-25-2007
SSIS - What is wrong with it

I recently visited a client that was achieving wonders with DTS, I was there to give them pointers on SSIS. I spent a day gogin over SSIS from the control flow to configrations. A couple of things really got me was that SSIS is a new world that youhave to learn and boy there is a lot to learn, SSIS has...

Posted to SimonS Blog on SQL Server Stuff (Weblog) by simonsabin on 07-27-2007

Page 1 of 4 (31 items) 1 2 3 4 Next >