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
Your favorite shows are back!
Don’t miss your dramas, sitcoms and reality shows. Find out when and where they’re airing!