Data in xml format

• ramrajan

  SSCommitted

  Points: 1737

  More actions

  February 22, 2015 at 8:14 pm

  #301420

  I have below two tables and i want the data to be exported to an xml file using SSIS,below i have mentioned the table schema and the xml output structure.

  create table Candidates(eno int,ResumeText varchar(30), Email varchar(30),Active varchar(30),postalcode varchar(30),country int)

  insert into Candidates

  select 1,'Test','ee@ee.com','Active yes','888888',2

  union all

  select 2,'Test','ee@ee.com','Active yes','888888',6

  create table CareerBuilderdatafeed (

  ClientKey INT ,

  VendorKey INT

  )

  insert into CareerBuilderdatafeed

  select 88, 99

  <?xml version="1.0" encoding="UTF-8" ?>

  <CareerBuilderdatafeed ClientKey="88" VendorKey="99">

  <Candidates>

  <Candidate>

  <ResumeText>Test</ResumeText>

  <Email>ee@ee.com</Email>

  <Active>Activees</Active>

  <Postal>888888</Postal>

  <country>2</country>

  </Candidate>

  - <Candidate>

  <ResumeText>Test</ResumeText>

  <Email>ee@ee.com</Email>

  <Active>Active yes</Active>

  <Postal>888888</Postal>

  <country>6</country>

  </Candidate>

  </Candidates>

  </CareerBuilderdatafeed>

• Eirikur Eiriksson

  SSC Guru

  Points: 182916

  More actions

  February 22, 2015 at 11:20 pm

  #1779181

  Duplicate post, answer on this thread

  😎