Configuring Derived Column Task and mapping

• Welsh Corgi

  SSC Guru

  Points: 116520

  More actions

  July 27, 2012 at 10:28 am

  #278728

  I have used the Derived Column Task before but I created the tasks and defined the derived columns but I can't remember the mapping part.

  [SSIS.Pipeline] Warning: The output column "STG_SOURCE_SYSTEM" (1208) on output "Derived Column Output" (1122) and component "Derived Column" (1120) is not subsequently used in the Data Flow task. Removing this unused output column can increase Data Flow task performance.

  I was looking for a good article that I found quite a while ago but I could not locate it.

  I have the following but it assumes that you know the mapping part.

  http://sqlyoga.com/2010/01/sql-server-ssis-derived-column-data.html

  Could someone please share with me a good article with screen shots?

  Thanks.

  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

  July 27, 2012 at 11:38 am

  #1518671

  I think that I found what I need.

  http://www.mssqltips.com/sqlservertutorial/211/sql-server-integration-services-ssis-data-flow

  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

  July 27, 2012 at 11:52 am

  #1518674

  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

  July 27, 2012 at 2:40 pm

  #1518760

  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