Data insertion query

• vasanti mestri

  Right there with Babe

  Points: 786

  More actions

  March 21, 2010 at 11:35 pm

  #139430

  Hi ....

  i have ine question.i am learning ssis now.so i dont have more knowledge abt same.

  i have one table in database from that i have to take three columns.and inser data in anothere destination table but with condition that if col.name like 'ins%' then insert 'insurance' ,if col.name like 'pes%' then insert 'admin' likewise i have more than 40 conditions.

  can you guys help me in ths?

  thanks in advance!!!!!!

• Katheesh.Kumar

  Newbie

  Points: 5

  More actions

  March 22, 2010 at 10:52 pm

  #1137971

  hi

  just go in for case statements to solve your problem for 40 conditions

• vidya_pande

  SSCertifiable

  Points: 5275

  More actions

  March 23, 2010 at 12:33 am

  #1137993

  Yes you can use case statement and generate dynamic SQL query.