December 30, 2008 at 6:49 am
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.
December 30, 2008 at 7:03 am
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.
December 30, 2008 at 8:05 am
:)ok. i will try..thanks a lot
January 12, 2010 at 8:02 am
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.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply