InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comWed, 22 May 2013 08:21:03 GMT20http://www.sqlservercentral.com/Forums/Topic627314-148-1.aspxIn 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 [b][i][u]not[/u][/i][/b] 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.Tue, 12 Jan 2010 08:02:22 GMTbrad.ashforthhttp://www.sqlservercentral.com/Forums/Topic627314-148-1.aspx:)ok. i will try..thanks a lotTue, 30 Dec 2008 08:05:43 GMTvrdjhttp://www.sqlservercentral.com/Forums/Topic627314-148-1.aspxThe 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.Tue, 30 Dec 2008 07:03:32 GMTErik Kutzlerhttp://www.sqlservercentral.com/Forums/Topic627314-148-1.aspxi 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.Tue, 30 Dec 2008 06:49:12 GMTvrdj