dbTalk Databases Forums  

add multiple dts packages into one job

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


Discuss add multiple dts packages into one job in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
sd
 
Posts: n/a

Default add multiple dts packages into one job - 10-19-2004 , 11:51 AM






If I have several dts packages(150) I want to run in one job how do I get
them into a job manually using their package name instead of the long id
number which is generate when you created the job from



Reply With Quote
  #2  
Old   
Darren Green
 
Posts: n/a

Default Re: add multiple dts packages into one job - 10-19-2004 , 12:06 PM






You can use DTSRUN yourself, as documented in Books Online or for some help
try DTSRUNUI,

Getting Syntax Help for DTSRun
(http://www.sqldts.com/default.aspx?301)

You create the job yoruself and then add a step, set to type CmdExec and
enter the command line for DTSRUN.


--
Darren Green
http://www.sqldts.com

"sd" <susan.dunn (AT) ncsl (DOT) org> wrote

Quote:
If I have several dts packages(150) I want to run in one job how do I get
them into a job manually using their package name instead of the long id
number which is generate when you created the job from





Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.