Flat File Insert Issue
Hi Guys,
Some reason. When I insert data into flat file its inserting "-" into empty columns. It suppose to be blank, I tried to replace "" instead of "-" using derived column still the same issue.
Also, data view doesn't show me "-" inside the columns, after the completion when I open the csv file I can see "-" inside the blank columns.
Any help much appreciated.
Thanks,
D
November 11th, 2010 8:38pm
what is your flat file connection manager settings?
did you check the data before insertion with data viewers?http://www.rad.pasfu.com
Free Windows Admin Tool Kit Click here and download it now
November 12th, 2010 1:57am