Need help in fixing the issue. Based on the below videos, I tried creating a job with xml as source but ended up with error related file path acess permission.
My question is : How can I acess xml from my local machine as source in the etl job. I remember after reading few thread , the file needs to be in job server. But in the video I don’t see that.
For your ETL server to see the file, you need to put the file on a visible server.
You can then create a nested schema using your xsd file. Sometimes when the file is on a server Designer can’t load the structure, so you put a copy in local and pick that XSD when you create the nested format. Then you pick the correct and save it. You later edit and replace the path by your server path.