I'm new to SSIS and I created a simple Data Flow task. The ADO NET Source shows all my varchar columns in ADO NET Source Output -> Output columns as Unicode string [DT_WSTR]. This is incorrect. The table in Sql Server uses only varchar columns. 开发者_Go百科I tried to add a Data Conversion transformation, but I still get errors about converting unicode strings. Why is SSIS reading my table schema incorrectly?
Thanks!
DT_WSTR is an SSIS datatype which I think SSIS covert's to if working on it. Though I don't know why it is in this case.
My recommendation would be to try using the OLEDB source and destination - they seem to have much more power and flexibility in SSIS.
精彩评论