Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 SSIS and Import/Export (2005)
 Import XML then wrtie to DB2

Author  Topic 

rwaldron
Posting Yak Master

131 Posts

Posted - 2009-06-08 : 07:58:27
Hiya all,
I have succesfully imported an XML file from a folder into sql table using microsofts example http://support.microsoft.com/kb/316005

However, Can someone help me do the following.

(1)I need to import the xml from a website and not a local folder
eg: http:\\website\customers.xml

(2)The XML's will be orders so I need to APPEND TO sql table

(3)I then wish to append these new orders to a table in DB2

Can someone please point me in the right direction
Do I need to use DTS or is this overkill
Thx,
Ray..

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2009-06-09 : 13:26:47
do you have a webservice for website from where you could get xml through method?
Go to Top of Page
   

- Advertisement -