Groups | Blog | Home
all groups > sql server dts > september 2006 >

sql server dts : DTS Compatibility between Service Packs



HudsonHawk
9/28/2006 12:01:01 PM
I have a workstation with SQL Server SP4, and a server with SQL Server SP3a.
I use Enterprise Manager on the workstation (SP4) to remotely connect to the
server (SP3a) and create/modify DTS Packages. If I create/modify a DTS
Package that contains a FTP Task from the workstation (SP4), and then
physically walk over to the server (SP3a) and try to open the package, I get
the error:

Error Source: Microsoft Data Transformation Serves (DTS) Package
Error Description: Unspecified error

I don't have the option of changing the SP level on either box. Is this a
known problem? And, are there any known fixes?

Thanks.
PSPDBA
10/5/2006 11:04:33 AM
Same boat here - I think we need a response from Microsoft.

It doesn't look like there is any way to save the DTS so it's
compatible..


[quoted text, click to view]
PSPDBA
10/5/2006 11:28:44 AM

[quoted text, click to view]
AddThis Social Bookmark Button