Pause SSIS Process Task

Whenever you are using a command line tool like bcp.exe in an execute process task, the command line window will pop-up and close very fast which makes it hard to debug.

A small trick is to put the executable in a batch file and throw in a pause and call the batch file from within the process task. Upon executing, the command line window appears and will continue after you press a key.

bcp_exe
using bcp.exe without a batch file
bcp_bat
using bcp.exe within a batch file

 

The batch file might look like this:

bcp.exe %*
pause

the %* accepts all the parameters passed from within SSIS to bcp.exe.

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>