Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
mshsilver
Posting Yak Master
112 Posts |
 Posted - 2009-08-04 : 03:48:13
|
| 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 completeAnd 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 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-08-04 : 07:55:19
|
| seems like there's some difference in way columns Student_Forename,surname exists on source and destination. just open package and right click on oledb source . it should try to correct inconsistency itself |
 |
|
|
|
|
|
external metadata column collection is out of sync