Different version of SQL Server (DTS)

Can I get high confidence that DTS packages (Saved as a *.DTS File) using SQL
Server Enterprise Manager 2000 (Based Version 8.00.194) on Windows XP Service
Pack 1 would run using SQL Server DTSRun.exe (Based Version 8.00.194) on
Windows 2000 Server SP3, if I can confirm that the DTS packages worked O on
DTSRUN.exe (Based version 8.00.194) on the same Windows XP Professional SP1
workstation?
Furthermore, if the DTSClients are upgraded later to SP2 or SP3, would there
be much issues?
Am I also right in thinking that the DTSRun.exe version can be of a
different (lower) version from the SQL Server 2000 database to which the DTS
packages will access and update?That worked for me.
--
HTH, Jens Suessmeyer.
--
http://www.sqlserver2005.de
--
"Patrick" <questions@.newsgroup.nospam> schrieb im Newsbeitrag
news:BE1EF7BB-F9FF-4AD6-9D3F-5D4A919BA10D@.microsoft.com...
> Can I get high confidence that DTS packages (Saved as a *.DTS File) using
> SQL
> Server Enterprise Manager 2000 (Based Version 8.00.194) on Windows XP
> Service
> Pack 1 would run using SQL Server DTSRun.exe (Based Version 8.00.194) on
> Windows 2000 Server SP3, if I can confirm that the DTS packages worked O
> on
> DTSRUN.exe (Based version 8.00.194) on the same Windows XP Professional
> SP1
> workstation?
> Furthermore, if the DTSClients are upgraded later to SP2 or SP3, would
> there
> be much issues?
> Am I also right in thinking that the DTSRun.exe version can be of a
> different (lower) version from the SQL Server 2000 database to which the
> DTS
> packages will access and update?|||> Can I get high confidence that DTS packages (Saved as a *.DTS File) using
> SQL
> Server Enterprise Manager 2000 (Based Version 8.00.194) on Windows XP
> Service
> Pack 1 would run using SQL Server DTSRun.exe (Based Version 8.00.194) on
> Windows 2000 Server SP3, if I can confirm that the DTS packages worked O
> on
> DTSRUN.exe (Based version 8.00.194) on the same Windows XP Professional
> SP1
> workstation?
Yes
> Furthermore, if the DTSClients are upgraded later to SP2 or SP3, would
> there
> be much issues?
No
> Am I also right in thinking that the DTSRun.exe version can be of a
> different (lower) version from the SQL Server 2000 database to which the
> DTS
> packages will access and update?
Yes, you're right.
Regards,
Kevin
"Patrick" <questions@.newsgroup.nospam> wrote in message
news:BE1EF7BB-F9FF-4AD6-9D3F-5D4A919BA10D@.microsoft.com...
> Can I get high confidence that DTS packages (Saved as a *.DTS File) using
> SQL
> Server Enterprise Manager 2000 (Based Version 8.00.194) on Windows XP
> Service
> Pack 1 would run using SQL Server DTSRun.exe (Based Version 8.00.194) on
> Windows 2000 Server SP3, if I can confirm that the DTS packages worked O
> on
> DTSRUN.exe (Based version 8.00.194) on the same Windows XP Professional
> SP1
> workstation?
> Furthermore, if the DTSClients are upgraded later to SP2 or SP3, would
> there
> be much issues?
> Am I also right in thinking that the DTSRun.exe version can be of a
> different (lower) version from the SQL Server 2000 database to which the
> DTS
> packages will access and update?|||Why have you not applied any services packs? Build 8.00.194 works, but there
are of course bugs otherwise MS would not have released 4 service packs
since then. You should apply service packs to clients as well as the server,
so that you get the benefit for the client components such as DTS.
Darren Green
http://www.sqldts.com
http://www.sqlis.com
"Kevin" <anonymous@.discussions.microsoft.com> wrote in message
news:eAsFI7oWFHA.1240@.TK2MSFTNGP14.phx.gbl...
> > Can I get high confidence that DTS packages (Saved as a *.DTS File)
using
> > SQL
> > Server Enterprise Manager 2000 (Based Version 8.00.194) on Windows XP
> > Service
> > Pack 1 would run using SQL Server DTSRun.exe (Based Version 8.00.194) on
> > Windows 2000 Server SP3, if I can confirm that the DTS packages worked O
> > on
> > DTSRUN.exe (Based version 8.00.194) on the same Windows XP Professional
> > SP1
> > workstation?
> Yes
> > Furthermore, if the DTSClients are upgraded later to SP2 or SP3, would
> > there
> > be much issues?
> No
> > Am I also right in thinking that the DTSRun.exe version can be of a
> > different (lower) version from the SQL Server 2000 database to which the
> > DTS
> > packages will access and update?
> Yes, you're right.
> Regards,
> Kevin
> "Patrick" <questions@.newsgroup.nospam> wrote in message
> news:BE1EF7BB-F9FF-4AD6-9D3F-5D4A919BA10D@.microsoft.com...
> > Can I get high confidence that DTS packages (Saved as a *.DTS File)
using
> > SQL
> > Server Enterprise Manager 2000 (Based Version 8.00.194) on Windows XP
> > Service
> > Pack 1 would run using SQL Server DTSRun.exe (Based Version 8.00.194) on
> > Windows 2000 Server SP3, if I can confirm that the DTS packages worked O
> > on
> > DTSRUN.exe (Based version 8.00.194) on the same Windows XP Professional
> > SP1
> > workstation?
> >
> > Furthermore, if the DTSClients are upgraded later to SP2 or SP3, would
> > there
> > be much issues?
> >
> > Am I also right in thinking that the DTSRun.exe version can be of a
> > different (lower) version from the SQL Server 2000 database to which the
> > DTS
> > packages will access and update?
>