Solved

Call a SSIS package from a Stored Proc SQL 2005

Posted on 2011-02-11
2
363 Views
Last Modified: 2012-08-13
I have a SSIS package that is located in the Integration Services\Stored procedures\MSDB\VantageImports\

I want to be able to call a Stored Proc that will run this SSIS package.

The reason is we have Softtree 24x7 as our scheduler..(for now) and i know how to call a Stored Proc from that software but i cannot figure out how to call a SSIS package and i am to frustrated to keep trying to research.. (everyday i have to get up at 3 am to run 7 SSIS packages.. untill i can get this automated) so to make things simple ... can i just call a SP from 24x7 that will run a SSIS package please. nothing fancy the SSIS is self contained.. nothing to send to it and nothing to get back from it...
0
Comment
Question by:PSIUnit
2 Comments
 
LVL 5

Expert Comment

by:robertg34
ID: 34875049
Can Softtree 24X7 call a .cmd or .bat job?  If so you can run the ssis package from there.  

0
 
LVL 15

Accepted Solution

by:
Aaron Shilo earned 500 total points
ID: 34881672
hi
this is very simple.

Create procedure My_Proc
as
begin
exec Xp_cmdshell 'dtexec /file "c:\ssis\myssispackage.dtsx" /checkpointing off /reporting E'
end


ENJOY
0

Featured Post

How to improve team productivity

Quip adds documents, spreadsheets, and tasklists to your Slack experience
- Elevate ideas to Quip docs
- Share Quip docs in Slack
- Get notified of changes to your docs
- Available on iOS/Android/Desktop/Web
- Online/Offline

Join & Write a Comment

Suggested Solutions

Introduction SQL Server Integration Services can read XML files, that’s known by every BI developer.  (If you didn’t, don’t worry, I’m aiming this article at newcomers as well.) But how far can you go?  When does the XML Source component become …
The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
Via a live example, show how to shrink a transaction log file down to a reasonable size.
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

705 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

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now