Mark Barto's Blog
Technical Blog about the Microsoft .NET Platform and everything that surrounds it such as .Net, C#, BizTalk, WCF, ASP.NET, SQL, Silverlight, IIS ...SQL, SSIS: Execute SSIS Package within Stored Procedure
I have a stored procedure which returns data from a database. Before I want to return this data I want to execute a SSIS package which populate this data. Unfortunately there is not any SQL statement to start a SSIS package within a Stored Procedure. But there is a work-a-round for it.