Importing XML file to SQL database

• sandyschiru

  SSC Enthusiast

  Points: 166

  More actions

  September 12, 2011 at 9:47 am

  #247629

  Hi,

  I am new to SSIS. I am importing the data from xml file to sql table. However i need to add the file path in the first column of the destination table and the current time in the last update column of the destination table.

  Please provide me some inputs.

  Thanks,

  Sandesh

• GSquared

  SSC Guru

  Points: 260824

  More actions

  September 12, 2011 at 11:39 am

  #1380239

  In the data flow, between the source and the destination, you can put a Derived Columns object, and you can map variable values into columns in that.

  - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
  Property of The Thread

  "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon