Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Grifter
Constraint Violating Yak Guru
274 Posts |
 Posted - 2012-07-04 : 08:48:11
|
HiI have a BAT file with 4 calls to different SSIS packages but the thing is the time taken to execute varies so sometimes my manually entered wait time is ran over by the previous package finishing late and the next process call starting:START DTEXEC.exe /F "mySSIS.dtsx"IF %ERRORLEVEL% NEQ 0 EXIT /B %ERRORLEVEL%timeout /t 370START DTEXEC.exe /F "mySSIS2.dtsx"IF %ERRORLEVEL% NEQ 0 EXIT /B %ERRORLEVEL%timeout /t 370START DTEXEC.exe /F "mySSIS3.dtsx"IF %ERRORLEVEL% NEQ 0 EXIT /B %ERRORLEVEL%timeout /t 370START DTEXEC.exe /F "mySSIS4.dtsx"IF %ERRORLEVEL% NEQ 0 EXIT /B %ERRORLEVEL%timeout /t 370 What I really need is something to say from the SSIS to say yes I have finished, the BAT file to read it and then carry on.Any ideas? I'm quite new to SSIS and cannot find anything that helps me on the net.ThanksG |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2012-07-04 : 09:08:18
|
If you would use sql server agent job with 4 steps then you would not have that problem.The job could be started from bat file like this:http://www.sqlservercentral.com/articles/Jobs/66421/
No, you're never too old to Yak'n'Roll if you're too young to die. |
 |
|
|
|
|
|
Timing of an SSIS package