kbnyny (4/16/2014)
Error msg say " The data type for input column "Copy of XML_f52e2b61-18a1"(330)" is DT_NTEXT.When I change encoding to unicode and the data type DT_NTEXT to that this is what I'm getting. I am making the change in connection manager.
none?PLastName?PFirstName?
????????????????????????????????????
The error is probably a bit longer that just that.
Check the error window to find the full error.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP