How to overcome this??

• md.noorullah

  Say Hey Kid

  Points: 691

  More actions

  January 12, 2009 at 6:42 am

  #155114

  I have Table- TableA in ABC server

  and another table TableB in XYZ server.

  I am using SSIS package to pull the records from TableA to TableB. But One of the column is of type "SQL_Variant".

  In OlEDB Source I cast 'ed it to NVARCHAR(4000) in order to avoid the warning..

  But now iam getting the below warning..

  Warning8Validation warning. DFT-TableB: {cd64d0af-b7c9-4ea1-a538-ea67129b1de6}: The input "OLE DB Destination Input" (622) references an external data type that cannot be mapped to a Data Flow task data type. The Data Flow task data type DT_WSTR will be used instead. PACKAGEABC.dtsx00

• Jack Corbett

  SSC Guru

  Points: 184394

  More actions

  January 12, 2009 at 9:34 am

  #925359

  Duplicate post please reply here: http://www.sqlservercentral.com/Forums/Topic633268-148-1.aspx

  Jack Corbett
  Consultant - Straight Path Solutions
  Check out these links on how to get faster and more accurate answers:
  Forum Etiquette: How to post data/code on a forum to get the best help
  Need an Answer? Actually, No ... You Need a Question