DTS packages

[cobbmj]

I am trying to create a single error.bat file for my dts package whereby the single error.bat holds different descriptions.

So if process 1 - Get files fails the error "Get Files failed" is produced in a cmd window
if process 8 fails - "FTP files failed" and so on.

I therefore have about 12 different Batch files whichj is a pain.


Does anyone know of a better way to do this or how to incorporate all the errors in one batch.



Many thanks

 

[quatermass]

Hi,

If you are using the Execute Process Task, it is very simple:

Write error.bat to accept parameters, eg
echo %1

where 1 represents the first parameter in a command line run and % is a reserved symbol for input parameters.

In the Execute Process Task, as the parameter put the error message you want to display.


This is the equivalent of running from DOS the line:
error.bat "message"
Which would show in a DOS window the line "message"

I hope that this is clear enough for you. I know it works as I use it to re-use batch files in my own DTS packages.


Kevin **************************************************************
Rock is Dead (Long Live Paper and Scissors)**************************************************************

 

[cobbmj]

Excellant thanks very much Kevin

 

[tlbroadbent]

Please post DTS questions in forum961. If you want to get the best answer for your question read faq183-874 and faq183-3179.
Terry L. Broadbent - DBA
SQL Server Page:

http://tlbroadbent.home.attbi.com/sql/sql_articles.htm