Post reply

SSIS : script task

  • April 13, 2016 at 6:51 am

    #315514

    Hi All,

    I have one predefined excel sheet where multiple columns are present in scattered form.

    I want to load data for respective column in respective excel cell dynamically. Those headers will not change.The values in tables are more.

    I don't know how script task work but I am trying but somehow not able to achieve this.

    Could you guys please help me on this ?

    I have searched over internet but didn't find any relevant answer.

    Thanks in advance 🙂

  • April 13, 2016 at 7:59 am

    #1871695

    Nikku (4/13/2016)

    Hi All,

    I have one predefined excel sheet where multiple columns are present in scattered form.

    I want to load data for respective column in respective excel cell dynamically. Those headers will not change.The values in tables are more.

    I don't know how script task work but I am trying but somehow not able to achieve this.

    Could you guys please help me on this ?

    I have searched over internet but didn't find any relevant answer.

    Thanks in advance 🙂

    Loading of data from Excel files whose format changes is not easily achieved in SSIS. What do you mean by 'scattered'?

    The absence of evidence is not evidence of absence.
    Martin Rees

    You can lead a horse to water, but a pencil must be lead.
    Stan Laurel

  • April 13, 2016 at 11:53 pm

    #1871905

    Hi Phil,

    Cell A Cell B Cell C Cell D Cell E Cell F

    Column1Column2column3

    1 2 3

    COlumn4COlumn5COlumn6COlumn7COlumn8COlumn9

    4 5 6 7 8 9

    This is my excel format.. I want to load the data in respective columns in given way. hope this clears your question

  • April 14, 2016 at 4:42 am

    #1871933

    Nikku (4/13/2016)

    Hi Phil,

    Cell A Cell B Cell C Cell D Cell E Cell F

    Column1Column2column3

    1 2 3

    COlumn4COlumn5COlumn6COlumn7COlumn8COlumn9

    4 5 6 7 8 9

    This is my excel format.. I want to load the data in respective columns in given way. hope this clears your question

    Yuck!

    Are the column headings always on the same row?

    Is the number of rows of data consistent, or does it vary with each file you get?

    If these things are varying, I cannot think of any reasonable way of automating this.

    The absence of evidence is not evidence of absence.
    Martin Rees

    You can lead a horse to water, but a pencil must be lead.
    Stan Laurel

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

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