"VS_NEEDSNEWMETADATA" error coming RRS feed

  • Question

  • Hi 

    getting following error While Running SSIS Package

    [SSIS.Pipeline] Error: "Oracle Source" failed validation and returned validation status "VS_NEEDSNEWMETADATA".

     [SSIS.Pipeline] Error: One or more component failed validation.

     Using Oracle 12C 
    VisualStudio-2017, SqlServer -2016, 

    Connection used: Connection manager for Oracle Connection

    Anshuman Chowdhury

    Tuesday, June 4, 2019 11:08 AM

All replies

  • validation status "VS_NEEDSNEWMETADATA".

    "Needs New Metadata" means that the Definition of the data source (table, view) has change and so you have to refresh the Connection Manager to get the new meta data.

    Olaf Helper

    [ Blog] [ Xing] [ MVP]

    • Proposed as answer by ArthurZ Tuesday, June 4, 2019 3:09 PM
    Tuesday, June 4, 2019 11:20 AM
  • Hi c_anshu,

    Please refresh your Oracle Source and your Connection manager for Oracle Connection.

    Best Regards,

    Mona Lv

    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com

    Wednesday, June 5, 2019 3:26 AM