SSIS shell Problem - URGENT Help Please

[Database Administrator]

Hi

I have created a SSIS Package that has many steps - The first however is a
Script Task that runs a Shell command to Retrive the File that I need to
manipulate.

I have used the Shell() command in the Visual Studio for Applications
however whne the task is running this step is missed but does not error (in
debugging it just steps straight through it

I require urgent help on this Please

Thanks

Matt

[khalil_ACH]

Hi

I did have the same problem, here is how I fix it.
first you have to save the DTS cmd in bat file
then execute the bat file using the shell cmd.

Exple:
lsCmd = "DTEXEC /f " & lsPkgName & " /Reporting E >> """ & lb_Log_filename & ".txt" & """"
Write_To_File (lsCmd, "lb_filename.bat")

I hope this help

Khalil