| Author |
Topic |
|
berengar
Starting Member
21 Posts |
 Posted - 2008-09-25 : 12:22:50
|
| I had an SSIS package working and now when i try and run it I get this error Error at DTSTask_DTSDataPumpTask_15 [DTS.Pipeline]: "component "OLE DB Source" (1)" failed validation and returned validation status "VS_NEEDSNEWMETADATA". |
|
|
rgombina
Constraint Violating Yak Guru
319 Posts |
Posted - 2008-09-25 : 12:33:13
|
| Has there been a change in column name from source? |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-09-25 : 13:39:48
|
| Seems like a metadata change. It seems like metadata of your source table has changed. You can click on OLEDB source task to see what error is or hover over to red symbol over task icon (if present) and toll tip will provide you with possible warnings. |
|
|
|
sky2aone
Starting Member
5 Posts |
Posted - 2008-09-25 : 17:18:30
|
| try to see column data and see data type |
|
|
|
berengar
Starting Member
21 Posts |
Posted - 2008-09-26 : 06:41:16
|
| So far im checking and all column data seems to be the same as it was ... no new or modified columns to the tables where data is extracted from ... very strange ... |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-09-26 : 06:43:35
|
quote:
Originally posted by berengar
So far im checking and all column data seems to be the same as it was ... no new or modified columns to the tables where data is extracted from ... very strange ...
and no warnings on source task icon as well? |
|
|
|
berengar
Starting Member
21 Posts |
Posted - 2008-09-26 : 06:49:33
|
| shit ...Warnings areWarning 1 Validation warning. Data Flow Task: OLE DB Source [1]: The external metadata column collection is out of synchronization with the data source columns. The "external metadata column "BILLABLE SFR" (73)" needs to be removed from the external metadata column collection. The "external metadata column "POSTPONE/CALLBACK/TT" (70)" needs to be removed from the external metadata column collection. The "external metadata column "MIGRATION PARTIAL" (67)" needs to be removed from the external metadata column collection. The "external metadata column "MIGRATION ONGOING" (64)" needs to be removed from the external metadata column collection. The "external metadata column "MIGRATED" (61)" needs to be removed from the external metadata column collection. The "external metadata column "TIME_OF_TREATMENT" (58)" needs to be removed from the external metadata column collection. The "external metadata column "SORTING_ACTION_TIME" (55)" needs to be removed from the external metadata column collection. The "external metadata column "END_ACTION_TIME" (52)" needs to be removed from the external metadata column collection. The "external metadata column "END_ACTION" (49)" needs to be removed from the external metadata column collection. The "external metadata column "BILLABLE_ACTION" (46)" needs to be removed from the external metadata column collection. The "external metadata column "CAMPAIGN" (43)" needs to be removed from the external metadata column collection. The "external metadata column "CATEGORY" (40)" needs to be removed from the external metadata column collection. The "external metadata column "PRODUCT" (37)" needs to be removed from the external metadata column collection. The "external metadata column "AGENT" (34)" needs to be removed from the external metadata column collection. The "external metadata column "INTERACTION_ID" (31)" needs to be removed from the external metadata column collection. backoffice_france_oneshot_and_finished_new_LOOP (1).dtsx 0 0But we need these columns ... and all the mappings have been created ... strange .. as this SSIS works on another DB ... so the package has the mappings correctly configured ... a puzzler |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-09-26 : 06:52:02
|
| that means the source table to which you're mapped OLEDB task has changed the structure and no more contains these columns. Can you check if there were changes happened to source table after you created package. |
|
|
|
berengar
Starting Member
21 Posts |
Posted - 2008-09-26 : 06:56:28
|
| yes but this same exact package works on another DB .. that has the same columns .. so the mappings are correct .. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-09-26 : 07:21:42
|
quote:
Originally posted by berengar
yes but this same exact package works on another DB .. that has the same columns .. so the mappings are correct ..
that will work fine provided the structure of source table includes these columns in that db. Make sure the tables metadata is same in both the dbs. |
|
|
|
berengar
Starting Member
21 Posts |
Posted - 2008-09-26 : 11:36:02
|
| Now it it ... works ... there was some functions missing (that column creation depended on ) and some SP's were modified .. |
|
|
|
|
Error anyone know it ?