开发者

Why does ADO NET Source Show incorrect string data types by default?

开发者 https://www.devze.com 2023-02-06 18:33 出处:网络
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 tabl

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.

0

精彩评论

暂无评论...
验证码 换一张
取 消