copying the data to different tables ??

• mailrpy

  SSC Enthusiast

  Points: 159

  More actions

  November 27, 2007 at 7:58 am

  #184113

  Hello I'am new to SSIS and struggling hard to perform the tasks

  I have a table which has ssn and fei columns. In the destination table i have id_type,id_value, the data from the ssn and fei columns of the source table should go to the id_value and it should also update id_type with 1 for ssn and 2 for fei..

  Any idea how should i handle this?

  Also, I have 3 packages. Package 1 should execute first and go to the second package and then the third package.Can i perform this in a sequence container.

  Aprreciate your help !!

  Kind Regards

  rp

• Michael Earl-395764

  SSC Guru

  Points: 53873

  More actions

  November 27, 2007 at 8:24 am

  #754587

  Source:

  SSNFEI

  ------- -----------

  12343333

  23454444

  52126666

  Destination:

  ID_TypeID_Value

  ------------------

  SSN1234

  FEI3333

  SSN2345

  FEI4444

  SSN5212

  FEI6666

  1) Select the source table using a data source adaptor (OLEDB or DataReader will work fine).

  2) Multicast your dataset into two data sets (the Multicast component just makes a copy of your data set)

  3) Add a derived column to each output data set - one that adds the ID_Type for SSN and the other that adds the ID_Type for FEI

  4) Use an OLEDB Destination component into the destination table. Make sure you do not check off the table lock option if you use fast load

• Powichrowski Marek

  Hall of Fame

  Points: 3423

  More actions

  November 28, 2007 at 2:05 am

  #754858

  I think the best way is to use Script component (transform type) with asynchronous output.