Hello,
I'm trying to import some data from a spreadsheet to a database table from a package in integration services. The problem is that I see the data when I open the excel file but when I try to run my package , it doesn't insert any rows in the table and it finishes with a success status.
My excel file has some formulas to get the data from other worksheets. I added a Data Viewer and all I see is null values in every cell.
I need help...does anyone know what's wrong
Null values when extracting data from an excel file
Craig G
This may seem to be obviuos; but meake sure you are pointing to the right sheet. What happens when you click the preview button in the Excel source
Rafael Salas
j_o_h_a_n_n_e_s
When the workbook is open, the linked data works fine.
ClaudiaHelpOnVSTO
In my case, it happens in both situations, closed or opened. But it happens when I modify something in the sheet. I inserted some rows in blank and that's when I cannot read the data in SSIS. I still have the original file and I was able to import that specific sheet (before the change) to the database.
I did the same thing in another file(I’m looping through files) and it did OK, so I don't think the problem is the blank rows...
PrashG