Post reply

SSIS Package to export a stored proc result set to Excel file

  • January 18, 2008 at 11:21 pm

    #127517

    I have a stored proc that produces a result set.

    I can do "Execute SQL Task" with ADO.NET connection to specify the result set.

    1. How do I feed that result set to an excel file in that SSIS package?

    (what control items to use? My result set has 61 cols and the export wizard has a step that creates the Excel layout.)

    2. How do I assign Excel file name based on input parm and timestamp?

    (for example, if my stored proc has input parm @account='Jcrew' and the system timestamp is Jan 18 12:40AM, how do I tell it to export to an Excel file say c:\temp\Jcrew Jan 18 12:40AM.xls?

    thank you much.

  • January 22, 2008 at 6:55 am

    #770447

    Take a look at this article. It gives a detailed step by step.

    http://www.sqlservercentral.com/articles/Integration+Services/61542/

    Norman

    DTS Package Search

    http://www.dtspackagesearch.com/

  • January 22, 2008 at 9:56 am

    #770535

    Thanks! That article is very useful.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply