CODEWITHSUNDEEP
sqlxmlwebssis
Samantha De Castro
Samantha De Castro

Reputation: 21

How to load XML file using SSIS when my XML source is on the web

I have a XML source which is located on the web (www.exampleXMLfile.com/XML)

How will I load it to SSIS when the only option is from the file location or variable?

Upvotes: 2

Views: 363

Answers (1)

mhd swe
mhd swe

Reputation: 113

you can download the xml file local to your pc using

"HTTP Connection Manager" then read the xml file

Upvotes: 1

Related Questions