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

Hi, Use the dtexec command.

http://msdn.microsoft.com/en-us/library/ms162810.aspx

I wrote a batch file .. !

But it is not generating the excel sheet.

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

Select allOpen in new window

Have you had a look at the output of the command to ensure that it is not erroring?

Its running .. but i am not getting the output.

Do you suggest me to keep PAUSE keyword in dos command .. ?

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?

Do you have any sample batch file to execute .dtsx file ?

i thought executing .dtsx file as similar to executing .exe file.

EvilPostit ..!

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


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