dbTalk Databases Forums  

XML+DTS

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts


Discuss XML+DTS in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Sunny
 
Posts: n/a

Default XML+DTS - 12-23-2003 , 04:04 AM






Hi
I have a XML Sheet , I need to load that data to SQL Table
Thro DTS How do I do it ? In future release? Is microsoft
planning a Direct connection to XML ?
Thanks in Advance
Sunny

Reply With Quote
  #2  
Old   
Allan Mitchell
 
Posts: n/a

Default Re: XML+DTS - 12-23-2003 , 04:57 AM






Microsoft's support for XML in DTS promises to be better in the next release
yes.



--

----------------------------
Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org



"Sunny" <anonymous (AT) discussions (DOT) microsoft.com> wrote

Quote:
Hi
I have a XML Sheet , I need to load that data to SQL Table
Thro DTS How do I do it ? In future release? Is microsoft
planning a Direct connection to XML ?
Thanks in Advance
Sunny



Reply With Quote
  #3  
Old   
Allan Mitchell
 
Posts: n/a

Default Re: XML+DTS - 12-23-2003 , 05:00 AM



Microsoft will most likely make the support for XML sources/dests batter in
the next release yes.

For the present you might like to look at this site

http://www.sqlxml.org/default.aspx

--

----------------------------
Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org



"Sunny" <anonymous (AT) discussions (DOT) microsoft.com> wrote

Quote:
Hi
I have a XML Sheet , I need to load that data to SQL Table
Thro DTS How do I do it ? In future release? Is microsoft
planning a Direct connection to XML ?
Thanks in Advance
Sunny



Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.