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.

 All Forums
 SQL Server 2005 Forums
 SSIS and Import/Export (2005)
 external metadata

Author  Topic 

VT_Bassman
Starting Member

6 Posts

Posted - 2011-05-31 : 15:26:18
I changed my date columns in my database to datetime and the advanced mappings in my package are DB_Date. so why am I getting "external metadata coulmn collection is out of sync with the data source columns.

VT_Bassman
Starting Member

6 Posts

Posted - 2011-06-01 : 08:47:39
Anyone????
Go to Top of Page

VT_Bassman
Starting Member

6 Posts

Posted - 2011-06-01 : 10:05:42
Is there a way to re-create the external metadata collection?
Go to Top of Page

latch
Yak Posting Veteran

62 Posts

Posted - 2011-06-01 : 10:42:17
What is your source database type.I mean SQL or Oracle.
The best way is no need to change the source use derived column transformation in SSIS package to change the data type of source to map to your destination.
Go to Top of Page
   

- Advertisement -