February 11, 2009 at 10:18 am
OK, so now the managers have decided that in order to get from SQL Server 2000 to 2005 faster, we will just migrate from the 2000 server to the 2005 server first without converting our DTS packages to SSIS. Then after that is sucessfully running in production, we will convert the DTS packages to SSIS.
All fine and good, except that I do not know how to do that. That is:
1) What do I need, and need to do, to be able to run DTS packages on my SQL Server 2005 server (Win2003). Note that the 2005 server was NOT upgraded from 2000, it is a fresh install. And,
2) What do I need to do to enable the developers and DBA's to be able to edit and maintain the DTS packages on SQL Server 2005, until we are ready to convert them?
Thanks, ...
February 11, 2009 at 8:07 pm
bump?
March 19, 2009 at 11:00 am
Check these out:
http://www.simple-talk.com/sql/sql-server-2005/dts-to-ssis-migration/
_____________________________________________________________________________MCITP: Business Intelligence Developer (2005)
March 20, 2009 at 8:12 am
Hi,
You can run the package using DTSRun command line utility from your app/web server if you have sql server 2000 client installed.. No need to worry the DB server.. still you can point your 2005 server for all the DB operations.
And there is a patch available with Microsoft site to edit/manage legacy DTS packages. once you installed in your pc, then its very easy and there is some option in SQL Server 2005 management studio for legacy objects maintanence.
Good luck
thanks,
-Saravanan.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply