Post reply

Best way for Porting SQL 2000 DTS to SQL 2005 SSIS?

  • February 13, 2006 at 10:00 am

    #166856

    Can someone recommend the best way to port SQL Server 2000 DTS packages into SQL Server 2005?

    I need to port over 250 pkg's from 2000 to 2005 - many complex in nature !!  (any truth to the rumour that there is a 3rd party Vendor offering a product to enhance this migration?)

    -thx in advance

    BT

  • February 14, 2006 at 3:01 pm

    #620850

    Its not true migration...but you can move the DTS packages, and then execute them using Execute DTS 2000 Package task in SSIS. This could be a temporary way to get on 05 work on the migration to SSIS as time allows.

     

    The Execute Package task can run packages stored in the SQL Server msdb database and packages stored in the file system. The task uses an OLE DB connection manager to connect to SQL Server and a File connection manager to access the file system.

    See

    http://msdn2.microsoft.com/en-us/library/ms143501.aspx

    http://msdn2.microsoft.com/en-us/library/ms137609.aspx

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply