I would try following in DTS:
- Download XML file with File Transfer Protocol Task
- Import file into a table column with Read File Transformation
- Run your stored procedure with Execute SQL Task

Check http://www.sqldts.com for usefull DTS info.

>I will use OpenXML to import the data from XML file into database tables. The xml files are in FPT site. I need to read the data of that file into memory in Sql server. Then I can use following code to add data into table
>
>How can I get the data in XML file in FTP site and put into variable or table in SQL?
>
>
<snip>