October 13th, 2009
SSIS Configuration notes
The way I understood it, if you put a value in “set values” within your job step (calling an SSIS Package) it would overwrite what was in the SSIS Configuration table… apparently I was wrong. I tested this today. SSIS Configuration table is the winner.
I started my SQL career working with SQL Server 2000/2005 for a large MLS Software company in Knoxville,TN. I worked with it for a few years. Now I am a SQL Server Programmer for a large E-Commerce company working with SQL Server 2008 and SSIS. My coworkers and I completed a large data warehouse in November 2009.