viresh29 (6/4/2014)
As with My data I created one file and table Here I am attaching both.If you create package and It will throw you error at row 2.
Well, first of all, the data in your example are not empty strings, but a single space.
Secondly, if you configure the last column to be an integer in the flat file connection manager and you import actual empty strings (instead of a space), the flat file loads just fine.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP