Post reply

How to load data into excel destination

  • February 3, 2010 at 6:42 pm

    #137813

    Hi Everyone,

    I have a task where I need to load the data from sql server table into excel worksheet. The data columns at the source level changes (eg: First day only 5 columns from TEST1 table may be required and loaded into excel worksheet and second day only 8 colums from TEST1 table may be required and

    and loaded into excel worksheet) dynamically.

    I am using ole db source as my source and I have a procedure which creates the dynamic select statement defining what all columns are required for that day and I am calling that procedure name inside my ole db source and I need to load the data dynamically into one excel sheet. The source may have 5 or N columns and it should get loaded into blank excel sheet along with column names.

    Note: The sql server table is fixed but columns might be changing and destination excel file name is fixed and there are no column headings for the excel sheet as columns changes every day. The data always loaded into sheet1.

    Everyday the excel file after getting loaded is moved to some other location and new excel file with same name as previous will be placed at the same location.

    Any kind of help is appreciable.

    Thanks in advance.

  • February 4, 2010 at 8:48 am

    #1113797

    Hi Everyone,

    Can anyone throw some light on this problem...

    Thanks

  • February 4, 2010 at 10:41 am

    #1113874

    What you are trying to accomplish is not possible with the standard Data Flow Task. The data flow is by default static. If you can use third-party solution, I would recommend you check the commercial CozyRoc Data Flow Task Plus. It is an extension of the standard data flow task, with support of dynamic source and destination columns. You can also define a mapping dictionary between your source and destination.

    ---
    SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

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

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