dbTalk Databases Forums  

Launch a package via BATch file?

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


Discuss Launch a package via BATch file? in the microsoft.public.sqlserver.dts forum.



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

Default Launch a package via BATch file? - 12-04-2003 , 05:56 AM






Hi to all,

is it possible to lunch a DTS packet via a .BAT file or a line command under
windows 2000 pro?

Thanks in advace.

Massi



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

Default Re: Launch a package via BATch file? - 12-04-2003 , 06:01 AM






Yes, lookup up DTSRUN in SQL Server Books Online.
For help with the syntax, try the DTSRUNUI tool, click Advanced, Generate.


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

"Massi" <massi (AT) tiscali (DOT) it> wrote

Quote:
Hi to all,

is it possible to lunch a DTS packet via a .BAT file or a line command
under
windows 2000 pro?

Thanks in advace.

Massi





Reply With Quote
  #3  
Old   
Allan Mitchell
 
Posts: n/a

Default Re: Launch a package via BATch file? - 12-04-2003 , 06:03 AM



Use DTSRUN in the batch file

BOL:
mk:@MSITStore:C:\Program%20Files\Microsoft%20SQL%2 0Server\80\Tools\Books\cop
rompt.chm::/cp_dtsrun_95kp.htm

--
--

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

"Massi" <massi (AT) tiscali (DOT) it> wrote

Quote:
Hi to all,

is it possible to lunch a DTS packet via a .BAT file or a line command
under
windows 2000 pro?

Thanks in advace.

Massi





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.