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

How to execute a SSIS Package from MS DOS batch file?
chokkaStudentAsked:
Who is Participating?
 
EvilPostItCommented:
Your code above should be working. Ie...

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

Open in new window

0
 
EvilPostItCommented:
0
 
chokkaStudentAuthor 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
Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
EvilPostItCommented:
Have you had a look at the output of the command to ensure that it is not erroring?
0
 
chokkaStudentAuthor 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
 
chokkaStudentAuthor Commented:
Do you have any sample batch file to execute .dtsx file ?

i thought executing .dtsx file as similar to executing .exe file.
0
 
chokkaStudentAuthor 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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.