>I don't know anything about SSIS yet, but we are going to be implementing 2005 in the new few months. I need to write a somewhat complicated DTS and just wondered how I should approach it to make it fit with 2005 in the future.

I would recommend following books:

Professional SQL Server 2005 Integration Services (Programmer to Programmer) http://www.amazon.com/Professional-Server-Integration-Services-Programmer/dp/0764584359/ref=pd_bbs_sr_1/002-0350974-4600063?ie=UTF8&s=books&qid=1189622456&sr=8-1

The Rational Guide to Extending SSIS 2005 with Script (Rational Guides) http://www.amazon.com/Rational-Guide-Extending-Script-Guides/dp/1932577254

Expert SQL Server 2005 Integration Services (Programmer to Programmer) http://www.amazon.com/exec/obidos/ASIN/0470134119/sqldts1-20

--sb--