Execute Package using SQL

Question

How is it possible to execute a SSIS 2008 Package by using SQL in SQL Server 2008 ?

Mitch Wheat · Accepted Answer · 2011-12-29 00:23:35Z

3

Not directly from TSQL (you would have to use xp_cmdshell to run DTEXEC, but that's not recommended)

You can execute a SSIS Package:

Using SQL Server Business Intelligence Development Studio (BIDS)
Using the DTEXEC.EXE Command Line Utility
Using a SQL Server Agent Job
Using the DTEXECUI.EXE Utility

How to: Run a Package

Can you explain why you need to run from TSQL?

edited Dec 29, 2011 at 0:23

answered Dec 28, 2011 at 4:43

Mitch Wheat

302k44 gold badges482 silver badges552 bronze badges

Sign up to request clarification or add additional context in comments.

8 Comments

Sreejesh Kumar Over a year ago

In our application we have a command button to call a Stored Procedure which will execute the package. And its a requirement too. Thats why I asked about executing package using TSQL.

Sreejesh Kumar Over a year ago

command used in TSQL for executing ssis package. I found in one of our projects. the syntax is xp_cmdshell '<<DTEXEC SSIS_PATH>>'

Mitch Wheat Over a year ago

that's what I said in the first line of my answer!

Mitch Wheat Over a year ago

@Sreejesh Kumar: if this answer helped you please consider upvoting and/or accepting it.

billinkc Over a year ago

Please amend your question. Provide the stored procedure and sample parameters so that we can help you.

|

Collectives™ on Stack Overflow

Execute Package using SQL

1 Answer 1

8 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

8 Comments

Your Answer

Sign up or log in

Post as a guest

Related