Post reply

Excel reports Processing

  • January 22, 2009 at 9:27 am

    #133726

    Can Gurus shed some light in processing Excel Reports in SSIS. Our requirement is such that we have data with out label in Excel file that has to be loaded in Staging.

    for eg.

    Model Quantity Price

    Electronics (Category)

    Television (SubCategory)

    21" Flat 30 $200

    25" Non flat 12 $300

    Audi systems(SubCategory)

    21" Mini 33 $2300

    25" Hi-FI 123 $3300

    I have highlighted the column header that will come in report, and the Category,subcategory are mentioned for illustration.

  • January 22, 2009 at 1:56 pm

    #931448

    If you are exporting from SQL Server to Excel, just make sure that "First row has column names" is unchecked when you are defining the destination connection.

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

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