SSIS ignoring data in right aligned cells (import from excel)

Question

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Jack Corbett SSC Guru Points: 184394 More actions · Answer 1

Could you post some sample data in the format you are loading from, the table schema you loading it into, and the settings of your package?

I have never seen this problem, but with some data I could see if I can duplicate it and solve it.

lreid-662356 SSC Veteran Points: 203 More actions · Answer 2

I solved it...

SSIS takes a look at the frist 8 records guess at the data type. Anything that doesn't fall into their guess is considered null.

Solution set IMEX=1 in your conenction.

Jack Corbett SSC Guru Points: 184394 More actions · Answer 3

Thanks for posting the solution. So many times someone posts a question, solves it, and leaves us all hanging.

lreid-662356 SSC Veteran Points: 203 More actions · Answer 4

I hear ya brother... its the easy way out... then the next guys looking for the answer and can't find it

😀