Post reply

Excel Destination has some blank rows before data gets written to it.

  • September 18, 2007 at 3:03 pm

    #121702

    I am writing to an Excel Destination by using the Excel Destination file widget in an Integration Services package in Visual Studio .NET and for some reason the file skips the first 82 rows in the destination excel file.  That is the rows are left blank and the file the content in the file gets written from row 82 onwards.  I am even deleting the file at the end of the package and copying a blank template file over the one that is created, but the problem persists.  Any input on how to go about fixing this will be much appreciated.

     

    Thanks,

    Monisha

  • September 19, 2007 at 1:44 am

    #734485

    I may be wrong but I had a similair thing. What had happened in my case was row 10 had a space in one of the cells. SSIS would then start inserting after this row.

     

    Try highlighting the rows by clicking on the row numbers, not rows, and deleting them. That worked for me.

    Cheers,CrispinI can't die, there are too many people who still have to meet me!It's not a bug, SQL just misunderstood me!

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

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