Configuring Derived Column Task and mapping

Question

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Welsh Corgi SSC Guru Points: 116520 More actions · Answer 1

I think that I found what I need.

For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Welsh Corgi SSC Guru Points: 116520 More actions · Answer 2

I set the variables used by the Derived Column String and I had them mapped to VARCHAR Data Types.

I get the error:

Cannot convert between unicode and non-unicode string data types

When I drop the variable into the new derived column it does not allow me to change the Data Type.

I could not figure it out so I changed the Data Types in the Tables as nvarchar.

What can I do instead of changing the Table Data Type?

For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

robert.gerald.taylor SSChampion Points: 13133 More actions · Answer 3

You can add a data conversion task to change the data type from nvarchar to varchar. That is from WStr to Str (in SSIS data conversion task).

HTH,

Rob