Make sure you run Upgrade Advisor for the SQL 2000 database first to see if there are any issues that you can take care of before migrating. This is...

I don't know the cause, but have you run SQL Server Upgrade Advisor on the SQL 2000 databases to see if there are any upgrade issues?

Please don't post the same question in multiple forums. The question was answered here: http://www.sqlservercentral.com/Forums/Topic660012-8-1.aspx#bm660518

If your packages are stored in SQL Server, you can also view the log info by right-clicking on the package in the "Local Packages" list in Enterprise Manager and selecting...

Do you want to move the database to another SQL 2008 instance? If so, make a full backup and restore it on the destination instance. If the destination...

Thanks, Chris. I hadn't used dtutil, but I'll check it out now.

digitalox, read the discussion thread for this article. There's a post that describes how to do what...

You either have to open each package in Enterprise Manager and save it to a file or use DTSBackup2000, a free download available from SQLDTS.com http://www.sqldts.com/242.aspx. The advantage of...

kotlas7 (2/18/2009)

---

I do not want to make them as ssis packages. I just want to run those dts packages in sql server 2005. Inorder to acheive this what should I...

Have you looked at putting the connections in configuration files? I would think you'd be able to easily modify the config files without having to edit each package.

If the packages are saved with an owner password set, anyone who knows the password can edit, save, and run the package. See "Handling Package Security in DTS" in...

No, because the entire package is stored as binary data in sysdtspackages90.

If you connect to Integration Services in SSMS on the server where the packages are stored, you can right-click on a package and select "Export Package..." which will let you...

I've seen this error when accessing a file that is not on the server where the DTS package is running. If that's the case here, try using a UNC...

I'm pretty sure that date is not stored in any system table. Sorry

You can't right-click on a package in SQL 2005 Management Studio and create a job like you could in SQL 2000 Enterprise Manager. In SQL 2005, you have to...