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'?

    If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.

  • April 13, 2016 at 11:53 pm

    #1871905

    Hi Phil,

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

    Column1 Column2 column3

    1 2 3

    COlumn4 COlumn5 COlumn6 COlumn7 COlumn8 COlumn9

    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

    Column1 Column2 column3

    1 2 3

    COlumn4 COlumn5 COlumn6 COlumn7 COlumn8 COlumn9

    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.

    If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.

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

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