SSIS SCENARIO

• maheshkrishnas

  Ten Centuries

  Points: 1045

  More actions

  March 1, 2012 at 1:12 am

  #251629

  Hi all,

  I have a department details in a file,now i need to send data to target table . based on the parameter which i pass in package in ssis

  example:

  Deptno, Dname,Location

  10,Accounts,Tx

  20,sales,Dallas

  30,Marketing,CA

  Now if pass deptno as 10 then that department details should load into target , how to achieve this in SSIS .Can anyone help on this....

• Ant-Green

  SSC Guru

  Points: 113507

  More actions

  March 1, 2012 at 1:30 am

  #1453480

  Load the data into a holding table, then you could write a t-sql task to only copy the data you need passing in a variable