Post reply

excel in ssis package

  • May 29, 2008 at 9:01 am

    #122639

    I HAVE ONE MORE QUESTION REGARDING TO EXCEL

    IN ONE OF THE EXCEL SHEET I HAVE THE FIRST FOUR ROWS WHICh ARE NOT USEFULL TO ME

    so can u suggest me ssis package so that i can discard that first four rows in excel

    then taking from the fifth row as my column name

    please

    thanks and regards

    Prasanna

  • May 29, 2008 at 9:50 am

    #821832

    Either;

    Import the file as a CSV and tell the flat file connection manager to start from the 5th row.

    or

    Add a conditional split in your package to split out the first five rows based upon a criteria that is unique to them

  • May 30, 2008 at 12:02 am

    #822109

    Is your header row on the 5th row?

    I have one such a situation where my headers are all over the show (the horse has already bolted, there are thousands of branch excel templates out there being filled in as we speak).

    I resorted to some good old fashioned scripting to standardise my layout

  • May 30, 2008 at 12:12 am

    #822111

    hi ..

    yup my header is in 5 th row,,

    but the rows which r above is not usefull to me

  • May 30, 2008 at 12:16 am

    #822116

    Have you tried importing as csv and specifying that it should start at the 5th row?

    If this option fails, you may consider adding a scripting task which removes the first 4 rows.

    Or alternatively, have excel source to excel destination, where you specify a query which only exports info where the column is not blank.

  • May 30, 2008 at 1:53 am

    #822136

    hi

    thanks fo r u r kind reply

    i just want to ask u

    is there any option in excel editor to neglect first four rows ,,

    as that previlege is present in csv file

  • May 30, 2008 at 2:43 am

    #822149

    Hi,

    The closest you going to get is to probably specify your blank four rows excel workbook as source, and a different excel as destination.

    When you define your source, then use a query to eliminate any blanks.

    Not as far as I know is there an option to set this to ignore the first 4 rows.

    What makes you dislike the csv option?

    ~PD

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

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