converting smallint to int in ssis

• frdrckmitchell7

  Ten Centuries

  Points: 1351

  More actions

  January 27, 2021 at 5:44 am

  #3837869

  Hi clever guys

   

  I have two tables named dbo.jade.store and dbo.stage.Store.  The first has a column called store_number, PK smallint, not null and the other storeNumber, PK, INT not null.

  For some reason I cannot use a derived column or data conversion to change the store_number from smallint to int as the mapping won't work in the SCD.

  Can anyone tell me what I'm doing wrong apart from being stupid?

  Kind regards

  Fred

• frdrckmitchell7

  Ten Centuries

  Points: 1351

  More actions

  January 27, 2021 at 6:26 am

  #3837882

  Hi guys

  I've actually just created a second table with the right column, movef the data over and used that table instead.

  Thanks