export comma delimited data from one source file to two destination tables

• bmr270

  Default port

  Points: 1477

  More actions

  September 4, 2008 at 12:06 pm

  #124402

  I have to export comma delimited data from one source file to two destination tables.

  Example

  Data in source file

  Male,mike,nj,usa(4 columns)

  Female,nansy,8(3 columns)

  Table structures

  Destination 1) tblMale

  Sex char(4)

  Name varchar(20)

  State char(2)

  Country char(3)

  Destination 2) tblFemale

  Sex char(4)

  Name varchar(20)

  Age bigint

  Output in table “tblMale”

  Male,mike,nj,usa

  Output in table “tblFemale”

  Female,nansy,8

  Thanks,

  BMR

• tanmayi

  SSCommitted

  Points: 1691

  More actions

  September 19, 2008 at 3:56 am

  #874095

  You can use conditional split task to direct rows into different tables based on conditions