Home Forums Data Warehousing Integration Services How to convert the data from stored procedure to excel sheet through SSIS. RE: How to convert the data from stored procedure to excel sheet through SSIS.

  • April 29, 2013 at 8:25 am

    #1610835

    Daniel Bowlin (4/29/2013)

    I suggest you read these 2 links

    http://consultingblogs.emc.com/jamiethomson/archive/2006/12/20/SSIS_3A00_-Using-stored-procedures-inside-an-OLE-DB-Source-component.aspx

    http://social.msdn.microsoft.com/Forums/en-US/sqlintegrationservices/thread/e8645006-899a-40bb-b144-6d65ee0a6290/

    So the real challenge is getting the data out of the stored procedure. You could build a work table and then

    INSERT INTO dbo.WorkTable

    EXEC dbo.StoredProcedure

    Then you can SELECT columns FROM dbo.WorkTable to feed your data into an SSIS data flow and then flow that down to an Excel destination.

    A data flow can quite happily consume the results of a stored proc as an OLE DB source without the need for a work table.

    If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.