how to check DTS packages require changes in order to work on SSIS

• MSQLDBA

  SSCrazy

  Points: 2783

  More actions

  November 28, 2008 at 4:49 am

  #126171

  Hi dear all,

  i have created SSIS for DTS packages migration. Now the my problem is that how i can check the DTS packages require changes in order to work on SSIS. I am not understanding how to check this situation.

  Thanks in advance.

  rgrds,

  m.i.

  ________________________________________
  M.I.
  [font="Times New Roman"]

  Learning is a path with no destination...

  [/font]

• shmuel_v

  Old Hand

  Points: 354

  More actions

  December 1, 2008 at 3:49 am

  #905446

  Hi,

  What you need is : Microsoft SQL Server 2005 Upgrade Advisor.

• COZYROC

  One Orange Chip

  Points: 28499

  More actions

  December 1, 2008 at 9:27 am

  #905710

  Check also DTS xChange.

  ---
  SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

  

• Justin Lezon

  SSCommitted

  Points: 1937

  More actions

  December 2, 2008 at 5:47 am

  #906161

  Are you looking for a way to edit a DTS 2000 package that has been migrated to SSIS 2005? This article explains how to do that.