Be careful when following SSIS best practices

December 7, 2009

How do you set up SQL queries in your packages? Let's say you have an Execute SQL task and you need to use a large table join to query the source table. There are several ways you can store the queries, and you can even combine some of them. I'll list them here, but I may forget one (or one combination); don't take this as an exclusive list.

The article continues at http://www.infoworld.com/d/data-management/be-careful-when-following-ssis-best-practices-907