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

Question

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. 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!

Mr Shoubs · Accepted Answer · 2011-01-24 23:41:09Z

3

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.

answered Jan 24, 2011 at 23:41

Mr Shoubs

15.6k18 gold badges72 silver badges109 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Mr Shoubs Over a year ago

I'm not sure why ADO.Net is so poor - I know it is managed code, so I assume it is some sort of façade over some lower level stuff.

Shivprasad Koirala Over a year ago

Gosh ADO.NET is so poor.

Collectives™ on Stack Overflow

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

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related