Pass variables to a DTS

#1

Hello,

I want to know if I can pass variables to a DTS. I call my
DTS with this:

exec master.dbo.xp_cmdshell 'DTSRun /S
salmarjo /N "Genera_Archivo_Clasificados" /E'

I need to pass some variables to this DTS. Could I do that?

Regards,
Oswaldo

#2

If you are using SQL Server 2000 look at the /A switch.

--
--

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

"Oswaldo" <jmendieta (AT) comercio (DOT) com.pe> wrote

Quote:

Hello,

I want to know if I can pass variables to a DTS. I call my
DTS with this:

exec master.dbo.xp_cmdshell 'DTSRun /S
salmarjo /N "Genera_Archivo_Clasificados" /E'

I need to pass some variables to this DTS. Could I do that?

Regards,
Oswaldo

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

Pass variables to a DTS

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

Pass variables to a DTS - 10-06-2003 , 05:07 PM

Re: Pass variables to a DTS - 10-07-2003 , 12:39 AM