Feeds:
Posts
Comments

Posts Tagged ‘Export table as XML SQL Server’

1.Export Table Output as XML/Generate XML from Table

select * from [your_table_name] for Xml AUTO,elements,root(‘root_name’)

select * from [your_table_name] for Xml RAW,elements,root(‘root_name’)

Save the output as xml

2.Import XML File into SQL Server using SSIS

Open BIDS

Create a new Project/Package

Go to Data Flow Task drag one XML Source

Click on XML Source

Browse XML Source Location where you saved your xml file above

Click on Generate XSD and save this file to a location

Drag one OLE DB Destination Component and create connection to destination SQL Server Instance.

And Finally Map both

Run Package

Bye

Advertisements

Read Full Post »

%d bloggers like this: