FAcing loading issue in SSIS package

• santosh.bhanutej

  SSC Journeyman

  Points: 99

  More actions

  July 13, 2009 at 11:14 am

  #206853

  Hi,

  I am facing a problem in the SSIS package.

  I got 3 inputs.I want to load the data coming from these 4 outputs in a single table.

  the inputs are:

  input1 columns:

  salary

  empname

  department

  input2 columns:

  division

  name

  input 3 columns:

  location

  city

  I want my output in the following format:

  salary empname department division name location city

  Could anybody help me in this issue?

  Thanks,

  Santosh Bhanutej MV

• steveb.

  SSC-Forever

  Points: 46733

  More actions

  July 13, 2009 at 11:22 am

  #1024062

  You can do this in SSIS easily,

  what is the common column between the tables that you can join on?