August 18, 2008 at 11:16 am
What I am trying to do is get data on a scheduled basis from another system. They have provided a WebService that delivers XML data I can pull. That works great. My problem is I do not want to write any files to the Server during this process. I can pull the data into a variable and IF I save the XSD to a file I can read the data from the variable into a table.
Is there anyway to do this without the saved XSD file?
I tried to save use inline schema but since in Development mode the variable is empty that blows up, I can't even compile the SSIS.
August 18, 2008 at 12:41 pm
If I can not do this without a saved XSD file, can I specify the location/name of that XSD in the Config file?
August 18, 2008 at 1:11 pm
You have to have a physical XSD I'm afraid.
You can set this via a config file or a variable / expression.
You can also provide an URL for the XML filename which is handy.
Cheers,CrispinI can't die, there are too many people who still have to meet me!It's not a bug, SQL just misunderstood me!
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply