blogs.conchango.com

I thought it would be worth publishing a list of guidelines that I see as SSIS development best practices. These are my own opinions and are based upon my experience of using SSIS over the past 18 months. I am not saying you should take them as gospel but these are generally tried and tested methods and if nothing else should serve as a basis ...

Dynamically changing a SQL Server Integration Services (SSIS) package at runtime is something many SSIS designers will find themselves doing. There are a number of methods of doing this and I've covered the main ones already: Property Expressions (look out for property expressions in the pipeline - coming soon!) ...

I have aluded as to the use of SSIS property expressions quite a few times on this blog. Regular readers will know what I think of them by now - they're a great mechanism for dynamically modifying the behaviour of your SSIS package at runtime. In short, property expressions ROCK! Something that I haven't mentioned before but ...

Yesterday I posted a blog entry that explained some of the options available for dynamically changing SQL Server Integration Services packages at runtime. Paul Shotts posted a comment stating that in DTS he often used the ''Dynamic Properties Task'' to change the source and destinations of his data pumps and asked whether he was now prohibited ...