SQL Server Performance Forum – Threads Archive

transfer xml data

Using SSIS, how is it possible to transfer the content of an xml file into an xml/varchar(max) field of a table in sql server 2005?
Thanks

you can do this by using stored procedure —————————————-
Contributing Editor, Writer & Forums Moderator
http://www.SQL-Server-Performance.Com Visit my Blog at
http://dineshasanka.spaces.live.com/

http://support.microsoft.com/kb/316005 too. Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.

quote:Originally posted by dineshasanka you can do this by using stored procedure —————————————-
Contributing Editor, Writer & Forums Moderator
http://www.SQL-Server-Performance.Com Visit my Blog at
http://dineshasanka.spaces.live.com/

How? you mean using openxml? thanks

Did you read the link satya provided? Madhivanan Failing to plan is Planning to fail

quote:Originally posted by Madhivanan Did you read the link satya provided? Madhivanan Failing to plan is Planning to fail

Yes but do not want to use VB.
I am using sql server 2005.
Thanks

XML Bulk load deals with loading up the data initially into SQL server. To update/delete, try thishttp://msdn2.microsoft.com/en-us/library/aa258671(SQL.80).aspx. As you know SQL Server 2005 has native XML datatype that you can store the whole xml doc in a sql table column without breaking it up and saving it as a table. Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.

ok, thanks

]]>