locked
Integration Services Jobs failing RRS feed

  • Question

  • Hi SQL Community,

    I'm new to SSIS, but I have inherited some Integration Services jobs that we depend on that are failing now.

    I've attached an example error. Any suggestions or pointers would be appreciated!

    Friday, May 1, 2015 9:05 PM

Answers

  • Hi,

    This is normally a metadata issue. The source might have changed and your source xml metadata is not updated because of which it's throwing validation error.

    Open the XML source and refresh it. Should work

    Regards

    Friday, May 1, 2015 10:45 PM
  • Make sure the format of the XML and XSD files didn't change... else edit the package in SSDT/Visual Studio and check the Data Flow that has the XML source in it.

    Please mark the post as answered if it answers your question | My SSIS Blog: http://microsoft-ssis.blogspot.com | Twitter

    Saturday, May 2, 2015 5:39 PM

All replies

  • Hi,

    This is normally a metadata issue. The source might have changed and your source xml metadata is not updated because of which it's throwing validation error.

    Open the XML source and refresh it. Should work

    Regards

    Friday, May 1, 2015 10:45 PM
  • Make sure the format of the XML and XSD files didn't change... else edit the package in SSDT/Visual Studio and check the Data Flow that has the XML source in it.

    Please mark the post as answered if it answers your question | My SSIS Blog: http://microsoft-ssis.blogspot.com | Twitter

    Saturday, May 2, 2015 5:39 PM