DTS Compatibility between Service Packs

#1

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.

#2

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..

HudsonHawk wrote:

Quote:

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.

#3

HudsonHawk wrote:

Quote:

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.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

DTS Compatibility between Service Packs

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

DTS Compatibility between Service Packs - 09-28-2006 , 02:01 PM

Re: DTS Compatibility between Service Packs - 10-05-2006 , 01:04 PM

Re: DTS Compatibility between Service Packs - 10-05-2006 , 01:28 PM