Dts

[pranay]

hi all!!
am in the process of developing a DTS which will pick up a XML file from a predefined path and read that file and put the content of that XML file in the database (SQL 2000) in a table having 2 cols (record_count and Description ). record_count is an identity col. i need the contet of the file to be inserted into the column named description.

Can any one pls helpt me out. am writing it into SQL DTS in vbscript(activex scripting task).

Pls respond soon.
Tx all.

[Shuja Ali]

hi all!!
am in the process of developing a DTS which will pick up a XML file from a predefined path and read that file and put the content of that XML file in the database (SQL 2000) in a table having 2 cols (record_count and Description ). record_count is an identity col. i need the contet of the file to be inserted into the column named description.

Can any one pls helpt me out. am writing it into SQL DTS in vbscript(activex scripting task).

Pls respond soon.
Tx all.
Take a look at this thread
http://www.codeguru.com/forum/showthread.php?p=1307598#post1307598

[exterminator]

You could, alternatively, use the XML BULK INSERT for the XML data. That would enhance the performance if the volume of data is large. Have a look here - Performing Bulk Load of XML Data (http://msdn.microsoft.com/library/default.asp?url=/library/en-us/sqlxml3/htm/bulkload_7pv0.asp) and Using SQL Server's XML Support (http://www.awprofessional.com/articles/article.asp?p=102307&seqNum=13&rl=1). Hope this helps. Regards.