Error configure for data convertsion

• jmpbi89

  Newbie

  Points: 9

  More actions

  October 18, 2016 at 9:06 pm

  #331050

  Dear experts,

  I have 2 dbs named Corporate and Consumer that same everything( fieldnames, datatype...)located on 2 sparate servers, so now i need to use SSIS to load data from them into my dwh and give the name for each source as thier db name!. When i use the data convertsion to convert data type for RowID field and configure Error OutPut, i set redirect row but i got the error "Output Column Copy of RowID has to be created before input column RowID used"

  Could anyone help me to resolve this? i am new in SSIS.

  Thanks in advanced

  J.