Migration without backup-files *.dts

Hello All,

I have to

migrate SQL 2000 DTS-Packages to SQL 2005. My Problem is that I didn't saved my

DTS-Packages as files and the SQL 2000 Server exist no longer.

Actually I

have only the old hard disk with the SQL 2000 databases. Do you have any ideas

what can I do?

Thanks

Jonas

Jonas1980 wrote:

Hello All,

I have to migrate SQL 2000 DTS-Packages to SQL 2005. My Problem is that I didn't saved my DTS-Packages as files and the SQL 2000 Server exist no longer.

Actually I have only the old hard disk with the SQL 2000 databases. Do you have any ideas what can I do?

Thanks

Jonas

Do you have backups of the databases?|||Yes, I have!|||

Jonas1980 wrote:

Yes, I have!

You may be able to access the DTS packages by restoring the backups to SQL Server 2005.

Check this link for more details: http://msdn2.microsoft.com/en-us/library/ms143706.aspx

|||

I can

restore the databases, e.g. the msdb-database from the hard disk of my old

server. Do you know any possibility to migrate my dts packages that are saved

in the msdb database without a running SQL Server 2000?

|||If using local server packages you can do this. Get the old msdb online, does not have to be called msdb though, just need to mount the DB somehow. Then rip the contents of the sysdtspackages table into a real msdb DB's sysdtspackages table. You can even use DTS or SSIS to do the data transfer or even just a INSERT ... SELECT if both DBs are on the same server.