importing

• hassu

  SSC Veteran

  Points: 249

  More actions

  July 10, 2008 at 10:49 am

  #122362

  hello i am working on SSIS for importing data from oracle to sql server 2005. I am having a problem write now and i want someone to help me

  i have one table in sql and i want its data to be transfered to two tables in sql server.

  eg

  from emp in oracle

  to

  emp

  employee

  in sql with the same fields

  please help

• crazy4learn

  Old Hand

  Points: 394

  More actions

  July 13, 2008 at 8:41 pm

  #842171

  for more than one Destination ,you should you the Multicast function to travel yr source data in to more than 1 destination...

  ( bt u need to first do data converstion for some fields)

  thanks