none
SSIS Metadata error

    Question

  • Hi am not sure how to tackle the following error:

    [OLE DB Source [1385]] Warning: The external metadata column collection is out of synchronization with the data source columns. The column "ACTIONDate" needs to be updated in the external metadata column collection. The column "AppointmentDate" needs to be updated in the external metadata column collection.

    Does anybody have any ideas?

    Thanks



    Mr Shaw
    Tuesday, March 24, 2009 10:07 AM

Answers

  • the datatypes of your current data are not in sync with what the source was set to expect initially. if you are still in debug mode, open the source, and sync it with your current data.
    Nitin
    • Marked as answer by Mr Shaw Tuesday, March 24, 2009 10:34 AM
    Tuesday, March 24, 2009 10:15 AM

All replies

  • the datatypes of your current data are not in sync with what the source was set to expect initially. if you are still in debug mode, open the source, and sync it with your current data.
    Nitin
    • Marked as answer by Mr Shaw Tuesday, March 24, 2009 10:34 AM
    Tuesday, March 24, 2009 10:15 AM
  • I get these messages all the time.  They go away.  They come back.  It may happen with one source this time and another the next time.  But the data source is not changing at all.  It's like SSIS adds these phantom columns.




    Wednesday, May 05, 2010 6:56 PM