• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 676
  • Last Modified:

Import XML File through DTS Task

I want to import an xml file from an ftp site into a db table through DTS Task.

Can somebody please help me on this

Thanks

Aash.
0
matrix_aash
Asked:
matrix_aash
2 Solutions
 
dbbishopCommented:
I believe it needs to be done in an activeX script. See http://p2p.wrox.com/topic.asp?TOPIC_ID=37661
0
 
twoboatsCommented:
Have a look at t-sql OPENXML in books online
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now