We have one system that exports a table to a pipe-delimited "|" csv file, and another that reads the csv file into a very similar table.
One field in the table(s) is a nullable smallint.
When the values in the table are null, SSIS exports to the flatfile as an empty field, just two adjacent separators.
When I try to read that file back in, it generates an error, can't convert string to smallint.
So, what's up with that?
I suppose I can fix this one field, but is this going to be a general problem? Is there a quick fix other than put in my own transformation?
--- oh hey, I think I fixed it! Well, worked around it anyway. Went to the source in the dataflow, in the advanced editor changed the output column type to DT_I2. Now it imports as 0 instead of null. Hmm, is that good enough?
View Complete Post