Solved

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

Posted on 2010-11-25
8
1,642 Views
Last Modified: 2012-08-14
How to execute a SSIS Package from MS DOS batch file?
0
Comment
Question by:chokka
  • 4
  • 4
8 Comments
 
LVL 16

Expert Comment

by:EvilPostIt
ID: 34213297
0
 

Author Comment

by:chokka
ID: 34213829
I wrote a batch file .. !

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

Open in new window

0
 
LVL 16

Expert Comment

by:EvilPostIt
ID: 34216057
Have you had a look at the output of the command to ensure that it is not erroring?
0
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 

Author Comment

by:chokka
ID: 34219092
Its running .. but i am not getting the output.

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

Expert Comment

by:EvilPostIt
ID: 34228498
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
 

Author Comment

by:chokka
ID: 34378707
Do you have any sample batch file to execute .dtsx file ?

i thought executing .dtsx file as similar to executing .exe file.
0
 
LVL 16

Accepted Solution

by:
EvilPostIt earned 500 total points
ID: 34378785
Your code above should be working. Ie...

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

Open in new window

0
 

Author Comment

by:chokka
ID: 34465475
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

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
SQL Syntax: How to force case sensitive query? 2 55
Database maintenance 36 98
Database Owner 3 13
Upgrade dos 4.00.1111 11 27
Data architecture is an important aspect in Software as a Service (SaaS) delivery model. This article is a study on the database of a single-tenant application that could be extended to support multiple tenants. The application is web-based develope…
Hi all, It is important and often overlooked to understand “Database properties”. Often we see questions about "log files" or "where is the database" and one of the easiest ways to get general information about your database is to use “Database p…
In a recent question (https://www.experts-exchange.com/questions/29004105/Run-AutoHotkey-script-directly-from-Notepad.html) here at Experts Exchange, a member asked how to run an AutoHotkey script (.AHK) directly from Notepad++ (aka NPP). This video…
Exchange organizations may use the Journaling Agent of the Transport Service to archive messages going through Exchange. However, if the Transport Service is integrated with some email content management application (such as an antispam), the admini…

740 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question