SQLTeam.com | Weblogs | Forums

Run SSIS in SQL Job


I have an SSIS package with an XML file, and it works correctly when I ran it in SSDTD, but when I want to run it (the SSIS package) in SQL job I got an error about the path of the XSD file. How Can I handle it in the Config file or invariable in the SSIS package?
1- Error is: "This error is thrown by Connections collection when the specific connection element is not found. (path of .XSD).
Code: 0xC0047019 Source: Data Flow Task SSIS.Pipeline Description: XML Source failed the prepare phase and returned error code 0xC02090CF. End Error DTExec: The package execution returned DTSER_FAILURE (1)"
2- My SSDT 2017 and version 15.9.20
3- I'm using XML source file in Data Flow and set XSD location

I appreciated it if you can help me.

so what role does the xml play in your ssis package? are you consuming xml data coming from a file in a shared folder or coming from another source? and dumping the data into tables?