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 |
|
mateo958
Starting Member
14 Posts |
 Posted - 2009-12-10 : 03:17:09
|
Hello,in my package SSIS i have this advertissement.the external metadata column collection is out of synchronization with the data source columns [URL=http://img42.imageshack.us/i/erreur1r.jpg/] [/URL]If i click on "yes" or "no" i have this error...[URL=http://img42.imageshack.us/i/erreur1r.jpg/][/URL]Need help please. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-12-10 : 13:50:41
|
| it seems your source tables structure changed after creation of package. so as suggested you need to click on it to fix the errors in metadata and go to properties to add any new columns that were added to source. |
 |
|
|
mateo958
Starting Member
14 Posts |
Posted - 2009-12-14 : 09:39:51
|
| Thx, and after, when the package RUN, i have this message :"Warning: The output column "VAT" (1226) on output "OLE DB Source Output" (1136) and component "SRC TMP_CHAINAGE_INACTIF" (1126)is not subsequently used in the Data Flow task. Removing this unused output column can increase Data Flow task performance" |
|
|
|
svicky9
Posting Yak Master
232 Posts |
Posted - 2009-12-14 : 10:09:50
|
| Check the Transforms again and remove any unnecessary mappingshttp://www.sqlserver007.com |
|
|
|
|
|
|
The external metadata column collection is out ...