Execute .dtsx file from .bat ( Execute SSIS Package from MS DOS Batch file )

How to execute a SSIS Package from MS DOS batch file?
chokkaAsked:
Who is Participating?
 
EvilPostItConnect With a Mentor Commented:
Your code above should be working. Ie...

dtexec /f "C:\MedISReports\SalisburyExportExcelCC01.dtsx"

Open in new window

0
 
EvilPostItCommented:
0
 
chokkaAuthor Commented:
I wrote a batch file .. !

But it is not generating the excel sheet.
'dtexec /f "C:\MedISReports\SalisburyExportExcelCC01.dtsx"'

Open in new window

0
Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

 
EvilPostItCommented:
Have you had a look at the output of the command to ensure that it is not erroring?
0
 
chokkaAuthor Commented:
Its running .. but i am not getting the output.

Do you suggest me to keep PAUSE keyword in dos command .. ?
0
 
EvilPostItCommented:
No, you should be getting an output of some kind. The package should at least be validated before it is executed.

This is just a dtsx file. Its not stored in a SQL Server somewhere is it?
0
 
chokkaAuthor Commented:
Do you have any sample batch file to execute .dtsx file ?

i thought executing .dtsx file as similar to executing .exe file.
0
 
chokkaAuthor Commented:
EvilPostit ..!

dtexec /f "C:\MedISReports\SalisburyExportExcelCC01.dtsx"


The difference between your code and my code is .. i have single quote .. which you dont have.
0
All Courses

From novice to tech pro — start learning today.