Solved

Call a SSIS package from a Stored Proc SQL 2005

Posted on 2011-02-11
2
367 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

Simplifying Server Workload Migrations

This use case outlines the migration challenges that organizations face and how the Acronis AnyData Engine supports physical-to-physical (P2P), physical-to-virtual (P2V), virtual to physical (V2P), and cross-virtual (V2V) migration scenarios to address these challenges.

Question has a verified solution.

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

Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
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…
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
Via a live example, show how to setup several different housekeeping processes for a SQL Server.

733 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