Subscribe to this blog
Archives: May 2011
Use Connections Properly in an SSIS Script Task
There are lots of scenarios in SSIS where you'd want to use a connection within a Script Task. Unfortunately, the closest help documentation - the comments inside the Script Task itself - give you exceptionally poor advice:
To use the connections collection use something like the following:
ConnectionManager cm =…
To use the connections collection use something like the following:
ConnectionManager cm =…
0 comments, 945 reads
Posted in Todd McDermid's Blog on 31 May 2011
How To: Use the Same Data Flow Column Twice As a Parameter in SSIS
Every once in a while, you'll have a slightly more complex UPDATE statement in an OLE DB Command or Destination. You'll use an UPDATE statement or a destination table that needsto use data from one column in your data flow several times. A typical example is a range update:
UPDATE table1
SET column1 =…
3 comments, 207 reads
Posted in Todd McDermid's Blog on 18 May 2011
Runtime Interaction with SSIS Packages - Confirming Actions
In developing my data warehouse ETL processes, there are some packages and SQL Agent jobs that are both necessary to the process of deploying a new version of the ETL system - and yet are extremely dangerous. These packages "reset" certain control infomation to a known state, which is a destructive…
3 comments, 665 reads
Posted in Todd McDermid's Blog on 10 May 2011
Iterating Over Columns in the SSIS Script Component
Just recently a question was posed in the MSDN SSIS Forums about how to create a "generic" script component that would read all columns for each row passed through it in the Data Flow. The standard impetus for this kind of behaviour is a logging or auditing step in the Data…
7 comments, 1,701 reads
Posted in Todd McDermid's Blog on 3 May 2011