porting DTS 2000 embedded package task

• Barkstuff

  Say Hey Kid

  Points: 662

  More actions

  September 14, 2015 at 7:58 am

  #304500

  Hello, I have exported from SQL Server 2005 a DTS package that contains an "EXECUTE DTS 2000 Package Task" and the storage location for the package is "Embedded in Task". How can I extract the package?

  Thanks B

• michal.lisinski

  SSCertifiable

  Points: 7201

  More actions

  September 14, 2015 at 11:35 am

  #1826485

  Hi

  Could you check this link https://www.mssqltips.com/sqlservertip/3195/finding-execute-dts-2000-package-tasks-prior-to-upgrading-to-ssis-packages/, this document should help you.

  Br.

  Mike