Long live Data Transformation Services! It's there if you're still working out issues with SSIS. Just don't expect DTS to be available by default. Data Transformations Services (DTS) is long dead; or ...

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 ...