Calling SSIS from T-SQL

Last Post 13 May 2008 12:02 PM by SQLUSA. 2 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
stevoid1970
New Member
New Member

--
13 May 2008 06:46 AM
Has anyone found a way to call an SSIS package inside a proc. ?I don't want to create a job and call it, neither do I want to use sp_cmdshell if I can avoid it. Perhaps a function?
SQLUSA
New Member
New Member

--
13 May 2008 12:02 PM
I am afraid DTEXEC is the only way.

Here is a link: http://msdn.microsoft.com/en-us/lib...62810.aspx

Kalman Toth - Database, Data Warehouse & Business Intelligence Architect
SQL Server 2005 Training, SSAS, SSIS, SSRS: http://www.sqlusa.com/
SwePeso
New Member
New Member

--
14 May 2008 01:24 AM
Or write a CLR to do this?
You are not authorized to post a reply.

Acceptable Use Policy