CODEWITHSUNDEEP
sql-serverexcelssisconnectionbids
CodeKingPlusPlus
CodeKingPlusPlus

Reputation: 16081

SSIS Excel Connection Manager Error

I am trying to create an Excel Connection Manager from an Excel file that has 19,852 rows. After I select the file and the Excel Sheet and click ok, I get the following error:

value does not fall within the expected range

How do I fix this error? Let me know if you need more information!

Thanks

Upvotes: 2

Views: 5118

Answers (1)

milivojeviCH
milivojeviCH

Reputation: 1598

Try to apply the hints from this post: SSIS Excel Import Forcing Incorrect Column Type

Excel connector is famous for missing the correct data column types.

Upvotes: 1

Related Questions