kbnyny (4/16/2014)
right now there is no error because I have the data type set as Unicode text stream [DT_NTEXT]
What is the encoding of the flat file? ANSI, UTF-8 or unicode? Check in the connection manager.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP