Hope this helps.
I am newbie to batch files. Any help would be appreciated.
I want to execute a dtsx package first and when complete execute an ant file.
First, I want to check if any files (.txt) exists in a folder.
IF exists *.txt in D:\folder
(C:\SQL\ProjectName\bin - do I haveto set the path first?)
execute dtexec /f mypackage.dtsx
execute ant -buildfile D:\project\conf\file.xml
If no files exists and folder is empty : quit
Hope this makes sense,
Thanks for the warm welcome Kees!
Thanks for the suggestion to actually perform a search on Google, mind blowing! I have already searched around and have not been able to find a particular good tutorial.
Hence the post.
If you have a particular tutorial that you have used and would like to recommend that would be cool.
This is what I got so far and this works.
Is there anyway I can verify that the second process does not starts until the first has completed?
If exist C:\testFolder\testfile.txt (
echo file exists
dtexec /f loadRArecords.dtsx
REM(The next process should not start until the first one has completed)
ant -buildfile C:\Client\Tools\config\demo_1.xml
) else (
echo file does not exists
Turn up the volume with our Apple Byte sweeps!
Two lucky winners will take home the coveted smart speaker that lets Siri help you around your connected house. This sweepstake ends Feb. 25, 2018.