Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

SQLRunner

This blog is syndicated from SSIS - SQL Server Tidbits(http://www.josefrichberg.com/)

Archives: April 2010

SSIS : Using the VariableDispenser object within Script Components

 I have become accustom to modifying package variables within my Script Task using the VariablesDispenser  object.  It is convenient and powerful.  I started working with this object due to issues I found while hacking my way through SSIS2005.  I would put the variables in the ReadOnly…

Read more

0 comments, 581 reads

Posted in SQLRunner on 26 April 2010

SSIS : Using the VariableDispenser object within Script Components

 I have become accustom to modifying package variables within my Script Task using the VariablesDispenser  object.  It is convenient and powerful.  I started working with this object due to issues I found while hacking my way through SSIS2005.  I would put the variables in the ReadOnly…

Read more

2 comments, 1,213 reads

Posted in SQLRunner on 26 April 2010

SSIS : Conditional Split optimization

I have built an enormous number of packages for this project over the past few weeks (just over 60) and wondered if a conditional split case without a destination was efficient.  I have been using the Conditional Split component with one case going nowhere as a way to 'throw' out… Read more

0 comments, 221 reads

Posted in SQLRunner on 26 April 2010