Data Transformation problem in SSIS

• Grass

  Ten Centuries

  Points: 1149

  More actions

  June 27, 2012 at 8:11 pm

  #258207

  Hi:

  I am new to SSIS and SQL Server. I have a package that copy data from source table to destination table. In the source table I have column name 'ID' data type 'varchar'. the data in this column is something like this 'A123423'.

  In the destination table i have column 'ID' data type 'int' with a primary key. I can't able to copy data from source to destination because of the character with the number. how can i transform the data from source to destination without changing the datatype of the column in SSIS package.Is there any task that needs to be used between the source and destination data flow.Need help....

  thanks

• Rock from VbCity

  Hall of Fame

  Points: 3991

  More actions

  June 27, 2012 at 11:49 pm

  #1506457

  Duplicated post, answer given here

  Hope this helps,
  Rock from VbCity