DTS vs SSIS

		Wrox Programmer Forums > SQL Server > SQL Server 2005 > SQL Server 2005
DTS vs SSIS

SQL Server 2005 General discussion of SQL Server *2005* version only.

Welcome to the p2p.wrox.com Forums.

You are currently viewing the SQL Server 2005 section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com

July 23rd, 2008, 09:09 AM

carumuga

Authorized User

Join Date: Dec 2006

Posts: 62

Thanks: 0

Thanked 0 Times in 0 Posts

DTS vs SSIS

Hi,

In DTS i'm using ActiveX script, performing some manipulation with the filesystem and finally ending the script with "Main = DTSTaskExecResult_Success" or Main = DTSTaskExecResult_Failure. Is there any equivalent code available in the SSIS. I think the code can be directly migrated to SSIS as ActiveX support by backward compatability.

Thanks,
Chandra

__________________
Thanks,
Chandra

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Advantages of SSIS over DTS	carumuga	SQL Server 2005	1	September 11th, 2008 07:51 AM
Books on DTS to SSIS Migration	carumuga	SQL Server 2000	1	July 4th, 2008 09:57 AM
DTS to SSIS migration	gunjan.sh	SQL Server 2005	1	July 4th, 2008 09:54 AM
DTS - SSIS Migration Error	carumuga	SQL Server DTS	3	July 4th, 2008 09:47 AM