Blank Row comming out from Excel Source?

Hot Topic

Cannot apply formula to Rendered/exported report to excel format
Simple recovery and Full backup
Common Password
How to group the columns?
Attribute Relationships in Project Real
Does anybody know whether SQL2005's source control supports ClearCase?
How can I sort on an aggregate
lookup and commit; How it works
Notiification Services Tutorial
Error on an Execute SQL Task

SQL Server

Package variables in case of an Exception
BROKER_QUEUE_DISABLED problems
Performance Question about: ExecStoredProcedure with ATL OLEDB Consumer Templates.
StrToMember Execution Problem
deploying report models
0 Data Loss on MIRROR
"Slipt" rows based on datetime
Change request: Parameter mapping
footer not shown for subreports
Replication to IP addressed server

Blank Row comming out from Excel Source?

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 Simoes

Answer this question

Blank Row comming out from Excel Source?

Willfin David

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.
Marco Kotrotsos

How do i know there are empty rows
Blank Row comming out from Excel Source?

Answer this question