Post reply

external metadata column collection is out of synchronization

  • August 4, 2009 at 1:45 am

    #137102

    Hi,

    I’m running a .dtsx package (my first ever) to transfer a table with 110,000 rows from one SQL 2005 database on one server to a replicated table in another SQL 2005 database on another server, across a domain. I am using domain admin and SA in SQL. The data looks to be transferring ok but I have just noticed that there are a few warning messages, see below. The IT guy at this college setup permission so I am sure they are ok.

    Any help with this would be appreciated as it is going to be a live system. Bear in mind I’m new to dtsx packages!! I’m using an OLE BD SOURCE and OLE DB for the destination. I have searched for answers but not found anyone doing the same thing as me.

    Thanks in advance.

    Progress: Validating - 50 percent complete

    [OLE DB Destination [263]] Warning: The external metadata column collection is out of synchronization with the data source columns. The column "Student_Forename" needs to be updated in the external metadata column collection. The column "Surname" needs to be updated in the external metadata column collection.

    Progress: Validating - 100 percent complete

    And then a bit further on this warning.

    Progress: Validating - 50 percent complete

    [OLE DB Destination [263]] Warning: The external metadata column collection is out of synchronization with the data source columns. The column "Student_Forename" needs to be updated in the external metadata column collection. The column "Surname" needs to be updated in the external metadata column collection.

    Progress: Validating - 100 percent complete

  • August 4, 2009 at 8:11 am

    #1034262

    I'm pretty sure this is happening because the table you're transferring TO has been changed since you created the OLE DB Destination task. To fix it you can either regenerate the task by deleting and adding it new. Or you can right click the task, show advanced editor, input and output properties, ole db destination input, External columns and update the column which was changed to match the correct data type.

  • August 10, 2009 at 1:15 am

    #1036611

    Thanks for that. I removed the destination and set it up again and it worked with no warnings. Thanks again.

  • August 10, 2009 at 6:31 am

    #1036720

    Any time!

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply