October 16, 2010 at 11:34 pm
how to move data from DTS to SSIS? If u upgrade 2000 server to 2005 server?
October 17, 2010 at 2:44 am
You mean convert a package from DTS to SSIS?
There's a conversion wizard somewhere, I don't offhand know the link, but it's for simple packages. For more complex it's usually rewrite from scratch. Though you can just leave it as a DTS package and run that in SQL 2005. Both 2005 and 2008 can still run DTS packages.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply