Conversion of DTS 2000 Packages to SSIS Pcakages in SQL 2008

• tush002sunny

  Old Hand

  Points: 310

  More actions

  November 27, 2012 at 7:28 am

  #270698

  Hi ,

  I have 65 DTS:2000 packages in our project. I just want to convert all these packages to SSIS packages using SQL Server 2008.

  Can anybody please help me out with easiest way of doing this large amount of packages ?

  Please also give me the steps of doing this as I'm doing it for the first time ...

  Thanks in advance !!!

• Dennis Post

  SSCarpal Tunnel

  Points: 4473

  More actions

  November 27, 2012 at 8:43 am

  #1562724

  Have you searched at all yourself?

  Try googling "SQL migrate 2000 dts to SSIS"

  ---

  
  For better, quicker answers on T-SQL questions, read Jeff Moden's suggestions.[/url]

  "Million-to-one chances crop up nine times out of ten." ― Terry Pratchett, Mort

• hcprasadv

  Ten Centuries

  Points: 1215

  More actions

  December 29, 2012 at 12:50 am

  #1572306

  Microsoft Provided a detailed explanation on Migrating DTS packages to Integration Services in MSDN Site...

  http://msdn.microsoft.com/en-us/library/cc768544%28v=sql.100%29.aspx

  Also check...

  http://www.mssqltips.com/sqlservertip/1224/upgrade-sql-server-dts-packages-to-integration-services-packages/