neela
asked on
Running DTS Package from SQL Job Agent
How can I run the DTSRun Utility from SQLServer Job Agent
Can u specify the syntax to use DTSRun in the SQLServer Job Scheduler?
Can u specify the syntax to use DTSRun in the SQLServer Job Scheduler?
ASKER
How do we execute these packages from VB?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
The package could be stored either in msdb, repository or a com-structured file.
The syntax would be :
1] to execute a pkg saved in a com file would : dtsrun /Ffilename /Npackage_name /Mpackage_password
2] to execute a pkg save in the msdb: dtsrun /Sserver_name /Uuser_name /Ppassword /Npackage_name /Mpackage_password
3] to exeucte a pkg save in the repository : dtsrun /Sserver_name /Uuser_name /Rrepository_name /Ppassword /Npackage_name /Mpackage_password.
specify one of the steps of your job as type : Operating System Command (CmdExec)
and the command would be any one of the 3 syntaxes above.
Regards,
Sudhi.