Post reply

Dnyamic Excel Destination Connection

  • July 24, 2012 at 12:02 am

    #278530

    Hi,

    I am Using Data Flow Task in For Loop Container.

    In Data Flow Task I had designed for Data Import From Sql(Using OLEDB Source) and to Excel(Using Excel Destination)

    Now For every iteration,I will get different result set throgh OledB Source, for that I had wriiten Dynamic SQL Query in that.

    Now I my requirement is to import those output to different Excel Files.

    So,how to make Excel Destination Connection change for every iteration for this.

    Or How to make Excel Destination Connection Dynamic.

    Please Help.

    Thanks.

  • July 24, 2012 at 1:13 am

    #1516611

    With different resultset, do you mean different columns? Because that won't work in SSIS. The metadata in the dataflow is static, to ensure high performance.

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

  • July 24, 2012 at 1:23 am

    #1516618

    Hi,

    No,different Dataset means structure will remain the same,only data will change.

  • July 24, 2012 at 1:34 am

    #1516624

    Ah OK. To make your Excel Destination dynamic, you need to put an expression on the connectionstring property of the Excel connection manager.

    Not 100% sure, but I think the Excel file has to exist before you write data to it.

    Creating Excel Files (.xls) dynamically from SSIS[/url]

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

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

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