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.
| Author |
Topic |
|
Akila
Starting Member
1 Post |
 Posted - 2009-06-19 : 05:49:27
|
| Hi,I am archiving data from source table having xml datatype and I am not allowed to create any new objects in the source.So I am unable to use the common work around of converting the xml datatype to varchar while inserting data through link server.Could some one help me to load xml data from source to target with link server.Thanks,Akila. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-06-20 : 02:35:51
|
| are you looking for extracting data from xml and populating the target table or populating xml as it as to target table? |
 |
|
|
|
|
|
distributed transaction with xml datatype