Guest_imported
New member
- Jan 1, 1970
- 0
How could I pass parameters to dtsrun utility to execute a package in the command line? I am in a hurry to get through this. Thanks. David
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
How to pass parameter to DTSRUN for executing a package
- Thread starter Guest_imported
- Start date
- Status
It's a little late, I suppose. But, in case anyone else is trying to make this happen, here's what I do. It could be shortened.
Zatch
CREATE PROCEDURE spExecDtsSpecific_Load
(
@LOAD_NO int
)
AS
DECLARE @cmd sysname, @var sysname
SET @var = @LOAD_NO
SET @cmd = 'DTSRUN /S "(local)" /NSPECIFIC_LOAD_ASP /Uusername /Ppassword /A "LOAD_NO":"3"=' + @var + ' /E '
Exec master..xp_cmdshell
@cmd
GO
Zatch
CREATE PROCEDURE spExecDtsSpecific_Load
(
@LOAD_NO int
)
AS
DECLARE @cmd sysname, @var sysname
SET @var = @LOAD_NO
SET @cmd = 'DTSRUN /S "(local)" /NSPECIFIC_LOAD_ASP /Uusername /Ppassword /A "LOAD_NO":"3"=' + @var + ' /E '
Exec master..xp_cmdshell
@cmd
GO
- Status
Similar threads
- Locked
- Question