Converting DTS to Stored Procedures

• shivashankara9

  SSC Eights!

  Points: 859

  More actions

  August 14, 2012 at 6:24 pm

  #260757

  Hi,

  I have DTS packages and i need to convert those DTS packages to Stored Procedures in SQL Server 2008 R2.

  Some one please help me...how to do this process.

• SpringTownDBA

  SSCertifiable

  Points: 6917

  More actions

  August 14, 2012 at 9:11 pm

  #1525865

  1. Document current functionality of existing dts packages.

  2. Write stored procedures to duplicate functionality.

  Of course, it may be easier to recreate the dts packages as ssis packages, not stored procedures.

• Fernando Jacinto Alvarez

  SSC Veteran

  Points: 275

  More actions

  September 25, 2012 at 12:57 am

  #1541668

  You can use a tirad party tool like dos exchange from http://www.pragmaticworks.com