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?

Improve company productivity with a Business Account.Sign Up

x
 
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
Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

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
 
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
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.