Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Conversion of DTS 2000 Packages to SSIS Pcakages in SQL 2008 Expand / Collapse
Author
Message
Posted Tuesday, November 27, 2012 7:28 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, April 03, 2014 3:42 AM
Points: 9, Visits: 30
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 !!!
Post #1389189
Posted Tuesday, November 27, 2012 8:43 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, March 06, 2014 1:35 AM
Points: 178, Visits: 547
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.

"Million-to-one chances crop up nine times out of ten." ― Terry Pratchett, Mort
Post #1389246
Posted Saturday, December 29, 2012 12:50 AM
Right there with Babe

Right there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with Babe

Group: General Forum Members
Last Login: Friday, April 04, 2014 12:20 AM
Points: 728, Visits: 339
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/
Post #1401143
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse