DTS Packages in SQL Server 2000 (Windows 2000 vs. Windows 2003) -- sql server dts

guidry49
11/30/2005 12:12:04 PM

We have a database server (DWPROD) running Windows 2000 with SQL Server
2000(sp3) and mdac 2.7 sp1 refresh. We are migrating to a new database
server (DWSQL) with Windows 2003, SLQ Server 2000 (sp3) and mdac 2.8.

I have been unable to open dts packages (either structured storage files or
local packages) copied from DWPROD to DWSQL.

Is there a specific explanation for this?
--

Allan Mitchell
11/30/2005 9:34:15 PM

Errors?

[quoted text, click to view]

guidry49
12/2/2005 5:23:03 AM

The specific error is:

"The DTS host failed to load or save the package properly"
--
guidry49

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages about sql server dts

sql server dts : DTS Packages in SQL Server 2000 (Windows 2000 vs. Windows 2003)