Interop.DTS in SQL 2005?

Been given a vbs project that uses Interop.DTS object to dynamically create a DTS package for data transfer.

Will this code work on a SQL 2005 server?

I'm going to take a stab and say "no" because DTS is no longer shipped with SQL Server. Instead, the new product, SSIS is shipped with Standard, Enterprise, and Developer editions. SSIS contains its own API, of which Interop.DTS is not part of.|||Yeah, i'm assuming DTS isn't supported.|||The DTS runtime ships with SQL 2005 and is supported. It is an option during installation, and

the best thing about the DTS to SSIS migration story is that you can upgrade o SQL 2005, and DTS keeps working.

For more info try the documentation - Books Online - http://msdn2.microsoft.com/en-us/library/ms143706.aspx