DTS

• manoj2001

  SSCrazy

  Points: 2225

  More actions

  August 22, 2008 at 2:52 am

  #123184

  if i want to load a data from multiplt sources to single data pump (activex Script runtime in DTS), how can i do it in SSIS?

  i mean is it possible to do the same in SSIS.

  SSIS has many additional features too so i think it must have this functionality also??

  Manoj

• abmore

  Hall of Fame

  Points: 3628

  More actions

  August 22, 2008 at 5:13 am

  #861783

  Yes you can do it by using MERGE JOIN task after fetching the data from different sources.