CODEWITHSUNDEEP
sql-server-2008excelssis
user1990383
user1990383

Reputation: 125

Excel to SQL Server using SSIS

I am loading data from Excel Source to SQL Server destination. And it is working fine. The problem is the empty rows are also inserting into the database.

Can you help please. Thanks

Upvotes: 1

Views: 191

Answers (2)

Ann L.
Ann L.

Reputation: 13975

You could try introducing a Script Component into your data flow task. Although they're based on the idea of "read a record, process it, write it", I believe you have the option of NOT writing out a particular record. You could filter based on whether the row from Excel has content, or not.

Upvotes: 1

bhupendra patel
bhupendra patel

Reputation: 3179

Check the step 7 of article he has used conditional splits you can use something like that.

Upvotes: 1

Related Questions