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
November 27, 2012 at 8:43 am
#1562724
Have you searched at all yourself?
Try googling "SQL migrate 2000 dts to SSIS"
"Million-to-one chances crop up nine times out of ten." ― Terry Pratchett, Mort
hcprasadv
Ten Centuries
Points: 1215
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/
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply