Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1664
  • Last Modified:

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

How to execute a SSIS Package from MS DOS batch file?
0
chokka
Asked:
chokka
  • 4
  • 4
1 Solution
 
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
 
EvilPostItCommented:
Have you had a look at the output of the command to ensure that it is not erroring?
0
Visualize your virtual and backup environments

Create well-organized and polished visualizations of your virtual and backup environments when planning VMware vSphere, Microsoft Hyper-V or Veeam deployments. It helps you to gain better visibility and valuable business insights.

 
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
 
EvilPostItCommented:
Your code above should be working. Ie...

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

Open in new window

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

Featured Post

Visualize your virtual and backup environments

Create well-organized and polished visualizations of your virtual and backup environments when planning VMware vSphere, Microsoft Hyper-V or Veeam deployments. It helps you to gain better visibility and valuable business insights.

  • 4
  • 4
Tackle projects and never again get stuck behind a technical roadblock.
Join Now