SSIS in SQL Job

Anonymous
2020-08-28T13:21:45.977+00:00

Hi,

I have an SSIS package with an XML file, and it works correctly, but when I use 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?
I appreciated it if you can help me.

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,502 questions

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2020-08-28T13:44:27.47+00:00

    Hi YitzhakKhabinsky,

    What is your SSIS version? SSDT 2017, version 15.9.20

    Are you using SSISDB Catalog on the server? no

    Are you using XML Source Adapter or XML Task, operation Validation? XML Source

    Are you using a project-level connection to an XSD file? yes, when I use the XML source I have to set XSD location

    What is the exact error message? 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)

    Thanks for your attention and your help

  2. Monalv-MSFT 5,896 Reputation points
    2020-08-31T08:18:57.847+00:00

    Hi Zara,

    May I know if the user in the job has full permission to access the XSD file?

    Please refer to the similar thread : SSIS Import XML task running in SQL Server Agent fails.

    Best Regards,
    Mona

    If the response is helpful, please click "Accept Answer" and upvote it.