Subscribe to this blog
SQLRunner
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…
0 comments, 344 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…
2 comments, 744 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, 145 reads
Posted in SQLRunner on 26 April 2010