Post reply

OLE DB Excel Destination: How To Skip First 2 Rows in Spreadsheet for Imported Data

  • March 6, 2015 at 4:01 pm

    #295027

    I have a SSIS pkg. that runs a query against records in a SQL Server database, many times over in a loop, and exports records each time the query is run into uniquely-created Excel spreadsheets.

    This spreadsheet template file that I use over and over for this has the first 2 rows in the spreadsheets as header rows. I'd like to indicate that for the import of data into each spreadsheet, for the first 2 rows of the spreadsheet to be ignored, with the data from Excel starting in Cell A3 and going down from there.

    Is this easily accomplished?

    Thanks.

  • March 6, 2015 at 5:06 pm

    #1782314

    It's been a while since I've had to do this, but from what I remember...as long as the first 2 cells of the first 2 rows contain data, Excel will automatically start populating from the first open row (third row in your case).

  • March 6, 2015 at 5:18 pm

    #1782316

    That's awesome if that's the case. I'll try this out this evening. Many thanks again for the info!

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

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