Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AHaiken
Starting Member
2 Posts |
 Posted - 2006-04-21 : 10:46:26
|
| Hello!I'm using the SSIS Package Migration Wizard to migrate SQL Server 2000 DTS packages. I followed all of the steps documented in Microsoft's 'SQL Server 2005 Books Online Using the Package Migration Wizard'. After I completed the migration, it says "you should connect to the local instance of Integration Services in Object Explorere to see the migrated packages. If you selected SQL Server as the destination, the migrated packages will be visible under the MSDB node'." When I checked, nothing showed up in this area. The logs showed that the migration completed successfully, and the dbo.sysdtspackages90 showed all 22 packages that I migrated. Additionally, if I tried to use the wizard a second time, it tells me that the files have already been migrated. Has anyone else experienced this problem? If so, how did you rectify the problem? If you successfully migrated the SQL Server 2000 DTS to 2005 with the migration tool, could you tell me how you did it and where you were able to find the migrated packages in SQL Server 2005?Thanks!Amy |
|
|
AHaiken
Starting Member
2 Posts |
Posted - 2006-04-24 : 09:14:22
|
| Just in case someone else winds up with the same problem, I'm posting what someone had sent me. Pete helped me with the following solution:When running a default instance of SQL 2000 and a named instance of SQL 2005, I ran into a problem with the configuration of SSIS where it uses the default instance of SQL Server instead of the named instance. Look in this file:C:\Program Files\Microsoft SQL Server\90\DTS\Binn\MsDtsSrvr.ini.xmlIf the database server here is not your 2005 server, this could be part of your problem.-Pete |
 |
|
|
|
|
|
Problems with DTS Migration Tool