June 18, 2007 at 2:04 pm
We are migrating from SQLServer 2000 to SQLServer 2005. Two separate boxes. Have a few DTS packages we would like to migrate to 2005. Have used the migration wizard to attempt to move them. the wizard says they were moved over, but when we connect to the 2005 server, we can't find them on the 2005 server.
We're in the position of being the dba's for the SQLSERVER piece once the software is installed, but have no control of the physical box, or the installation of the modules needed to access the database.
We have the ability to connect to the 2005 database through both the database engine and through Integration Services.
Has anyome moved DTS packages from 2000 to 2005 successfully, and if so, how can you then change and/or schedule them to execute?
Any help would be greatly appreciated. (UserID=267905)
June 19, 2007 at 4:37 am
Once you have moved the DTS packages, you need to create a SSIS package and use the Execute DTS package task to run them either from the SQL store or a Structured file. You cannot "migrate" DTS packages to SSIS. You have to run them through SSIS.
Cheers,CrispinI can't die, there are too many people who still have to meet me!It's not a bug, SQL just misunderstood me!
June 19, 2007 at 10:26 am
Terrell,
If the packages were moved to SQL 2005 successfully, you can see them in SQL Server Management Studio by expanding Management, Legacy, Data Transformation Services.
Greg
Greg
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply