Hi,
I use an excel datasource to populate some simple dimensions, but when i extract the excel file i get alot of blank rows from the excel files...
How can i overcome this issue? Is this normal?
I never had problems like this using DTS in the 2000 version
Best Regards,
Luis Sim?es
Perhaps, your Excel file has empty rows in the spreadsheet.
You should not see any difference when using DTS or SSIS wizard if the same source file is used.
Thanks.
|||How do i know there are empty rows?
No comments:
Post a Comment