• Good article, everyone should be made aware that as SSIS has the ability to connect to numerous sources or destinations, not necessarily involving a SQL Server database.

    I used DTS for this sort of thing on many occasions, now we have even more sophisticated possibilities.

    Having said that, the syntax for the parameters appears inconsistent, I seriously need to spend a lot of time fiddling with these packages.

    Does anyone have a list of useful sources for examples of SSIS packages (as well as here and Microsoft)?