update column according to source

• weston_086

  SSCommitted

  Points: 1645

  More actions

  March 25, 2012 at 10:49 pm

  #253717

  create table updt(id int,sourcename nvarchar(10))

  insert into values(2),(3),(4)

  i have dimension table in which i am loading data from different sources in ID column.Now i want to update sourcename column

  according to the name of the source from which data is comming.for e,g "A" is coming from source1 so i want to update sourcename column as source1 and

  "Z" is coming from source3 so i want to update sourcename column as source3.I want to make it dynamically so that sourcename column would change according to

  source from data is coming.i want to do it when i am loading data using SSIS. my result should look like this.

  insert into values (A,'source1'),(X,'source2'),(Z,'source3')

• Koen Verbeeck

  SSC Guru

  Points: 259165

  More actions

  March 26, 2012 at 12:04 am

  #1464089

  Please do not crosspost. It wastes people's time and fragments replies.

  Original topic with replies can be found here:

  http://www.sqlservercentral.com/Forums/Topic1272434-391-1.aspx

  Need an answer? No, you need a question
  My blog at https://sqlkover.com.
  MCSE Business Intelligence - Microsoft Data Platform MVP