July 7, 2010 at 8:34 pm
Hi,
I am having problems, error, due to conversion between DT_STR and DT_TEXT. I have even used Data Conversion block in between my source and destination. I am still getting this problem? Any help on this.
The source is a .csv file while destination is an SQL Table. In the destination, I declared all the columns as type varchar(MAX) and even then also tried out, without using the conversion block, and I get the error saying Error at Data Flow Task [SQL Server Destination [3902]]: The column "Discovered Name" can't be inserted because the conversion between types DT_STR and DT_TEXT is not supported.
Any help will be greatly appreciated.
Thanks in Advance
July 8, 2010 at 9:11 am
You have to use a data conversion task to change the data from WSTR to STR or vice versa. It's like the difference between unicode and non-unicode characters. In fact, ISTR that it actually is the difference.
Once you do that, you should be fine.
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply