DTS for MSDE

#1

I need to create a DTS Export job that can be imported to
MSDE via script. But I need to be able to alter the
destination server in the script.

When I use DTS wizard to create the job and create a script
from it. I do not see how I can change the destination
server within the script, because it looks to be encoded.

Any Ideas?

#2

When you say change the destination, what do you mean? The destination
for a datapump?

If == Yes then does this help

Connections
(http://www.sqldts.com/Default.aspx?101)

Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org

#3

You can do this by using Dynamic Task properties in DTS ...

Kris.

"Jahnathan Cain" wrote:

Quote:

I need to create a DTS Export job that can be imported to
MSDE via script. But I need to be able to alter the
destination server in the script.

When I use DTS wizard to create the job and create a script
from it. I do not see how I can change the destination
server within the script, because it looks to be encoded.

Any Ideas?

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

DTS for MSDE

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

DTS for MSDE - 07-09-2004 , 02:22 PM

Re: DTS for MSDE - 07-09-2004 , 03:21 PM

RE: DTS for MSDE - 07-09-2004 , 05:51 PM