locked
Integration Services Jobs failing RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    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

  • Question
    Sign in to vote
    0
    Sign in to vote

    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
  • Question
    Sign in to vote
    0
    Sign in to vote
    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

  • Question
    Sign in to vote
    0
    Sign in to vote

    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
  • Question
    Sign in to vote
    0
    Sign in to vote
    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