dbTalk Databases Forums  

Execute a DOS batch file via a dts package..

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


Discuss Execute a DOS batch file via a dts package.. in the microsoft.public.sqlserver.dts forum.



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

Default Execute a DOS batch file via a dts package.. - 11-21-2005 , 09:52 AM






I am trying to figure out how to run a simple dos batch file after a step
within a DTS package completes...

For example:
A DTS Package uses a FTP TASK to transfer a file.
If successful then
Execute a batch file on c: called cleanup.bat

Any suggestions would be much appreciated...

Reply With Quote
  #2  
Old   
Kevin3NF
 
Posts: n/a

Default Re: Execute a DOS batch file via a dts package.. - 11-21-2005 , 10:30 AM






Add an "Execute Process" task to your package and specify the batch file in
the Win32 Process box

--
Kevin Hill
President
3NF Consulting

www.3nf-inc.com/NewsGroups.htm


"Warren" <Warren (AT) discussions (DOT) microsoft.com> wrote

Quote:
I am trying to figure out how to run a simple dos batch file after a step
within a DTS package completes...

For example:
A DTS Package uses a FTP TASK to transfer a file.
If successful then
Execute a batch file on c: called cleanup.bat

Any suggestions would be much appreciated...



Reply With Quote
  #3  
Old   
Warren
 
Posts: n/a

Default Re: Execute a DOS batch file via a dts package.. - 11-21-2005 , 10:45 AM



D'oh... Thanks I don't know why I did not think of that.. Good lord...

"Kevin3NF" wrote:

Quote:
Add an "Execute Process" task to your package and specify the batch file in
the Win32 Process box

--
Kevin Hill
President
3NF Consulting

www.3nf-inc.com/NewsGroups.htm


"Warren" <Warren (AT) discussions (DOT) microsoft.com> wrote in message
news:ACF6DAD7-3F01-451A-A342-6E5FCE144438 (AT) microsoft (DOT) com...
I am trying to figure out how to run a simple dos batch file after a step
within a DTS package completes...

For example:
A DTS Package uses a FTP TASK to transfer a file.
If successful then
Execute a batch file on c: called cleanup.bat

Any suggestions would be much appreciated...




Reply With Quote
  #4  
Old   
Kevin3NF
 
Posts: n/a

Default Re: Execute a DOS batch file via a dts package.. - 11-21-2005 , 11:13 AM



I've never actually used it, and completely amazed that I even remembered
that it exists. Normally I would said use xp_cmdshell to run the .bat....

Have fun,

--
Kevin Hill
President
3NF Consulting

www.3nf-inc.com/NewsGroups.htm


"Warren" <Warren (AT) discussions (DOT) microsoft.com> wrote

Quote:
D'oh... Thanks I don't know why I did not think of that.. Good lord...

"Kevin3NF" wrote:

Add an "Execute Process" task to your package and specify the batch file
in
the Win32 Process box

--
Kevin Hill
President
3NF Consulting

www.3nf-inc.com/NewsGroups.htm


"Warren" <Warren (AT) discussions (DOT) microsoft.com> wrote in message
news:ACF6DAD7-3F01-451A-A342-6E5FCE144438 (AT) microsoft (DOT) com...
I am trying to figure out how to run a simple dos batch file after a
step
within a DTS package completes...

For example:
A DTS Package uses a FTP TASK to transfer a file.
If successful then
Execute a batch file on c: called cleanup.bat

Any suggestions would be much appreciated...






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.