Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

How to execute ssis package through stored procedure Expand / Collapse
Author
Message
Posted Tuesday, December 30, 2008 6:49 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, January 22, 2009 5:33 AM
Points: 6, Visits: 24
i have created a package using sql export/import wizard to take backup of a table (saved in sql server 2005). is it possible to write a stored procedure to execute the package?

So that it can be called from the front end.when ever it's required..

Thank you in advance.

Post #627314
Posted Tuesday, December 30, 2008 7:03 AM
SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: Friday, August 31, 2012 10:31 AM
Points: 633, Visits: 1,695
The easiest way to do this would be to create a SQL job that executes the SSIS package, then execute the stored procedure master.dbo.sp_start_job to run the job.

You could also execute master.dbo.xp_cmdshell to run a dtexec command.
Post #627331
Posted Tuesday, December 30, 2008 8:05 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, January 22, 2009 5:33 AM
Points: 6, Visits: 24
:)ok. i will try..thanks a lot
Post #627374
Posted Tuesday, January 12, 2010 8:02 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Friday, September 30, 2011 8:37 AM
Points: 18, Visits: 42
In SQL2000 I had a project where we had to execute DTS packages from clients that didn't have SQL Server installed. For that project I did create a sp that would execute the DTS package. It made calls to spOACreate and others but you can call them in the correct context to avoid security issues.

I just saw this posted today (I am not the author, indicating a method to do the same w/SSIS. I have not tested it but thought it should be posted for review in case anyone can use it.
Post #846184
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse