Post reply

How do i transfer DTS Packages from SQL2000 to SQL2K8?

  • April 2, 2010 at 7:08 am

    #220027

    Hi All,

    How do i transfer DTS Packages from SQL2000 to SQL2K8? Is there any feature pack, you know?

    Regards,

  • April 5, 2010 at 2:33 pm

    #1146005

    Are you looking to run these as DTS packages on SQL 2008 or convert them to SSIS? I would recommend converting to SSIS if time permits.

    For DTS support, check the following link:

    http://msdn.microsoft.com/en-us/library/bb500440.aspx

    For converting to SSIS, I have found it easier to just code them fresh using the DTS package as a reference. The utility provided with SQL server doesn't get everything. There are other utilities out there but I have not used them. Maybe someone else can help with that.

    -Brian

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

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