Post reply

SSIS Newbie

  • December 17, 2012 at 2:32 am

    #267619

    Hi All,

    I am new to SSIS,I have given task of implementing the following task

    create SSIS packages which takes input parameters and call stored procedure and the result set of the stored procedure is exported to new excel sheet dynamically.

    Can you guys guide me

    Thanks

    Ningaraju N E

  • December 17, 2012 at 2:47 am

    #1569060

    This isn't something that can really be answered in a forum post. Try going through this[/url], and post back if there's anything you don't understand.

    John

  • December 17, 2012 at 2:57 am

    #1569065

    Thanks John,

    But no link is attached.

  • December 17, 2012 at 2:59 am

    #1569066

    Click on the word "this" in my previous post, or copy and paste this into your address bar:

    http://www.sqlservercentral.com/stairway/72494/

    John

  • December 17, 2012 at 3:27 am

    #1569079

    ningaraju.n (12/17/2012)

    Hi All,

    I am new to SSIS,I have given task of implementing the following task

    create SSIS packages which takes input parameters and call stored procedure and the result set of the stored procedure is exported to new excel sheet dynamically.

    Can you guys guide me

    Thanks

    Ningaraju N E

    Did you try something ?

    Also when you say dyanmically so there is a question that result set of SP is having dynamic pattern or same pattern every time.

  • December 17, 2012 at 3:35 am

    #1569083

    SP will return same pattern always

  • December 17, 2012 at 3:56 am

    #1569086

    You can have the stored procedure in the OLE DB source in the dataflow. You can map parameters into the stored procedure. Be aware that stored procedures can behave oddly in the OLE DB source: Using stored procedures inside an OLE DB Source component

    You can put an expression on the Excel connection manager to create a new Excel file every time the package runs.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

Viewing 7 posts - 1 through 6 (of 6 total)

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