Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

external metadata column Expand / Collapse
Author
Message
Posted Wednesday, January 16, 2008 10:25 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Wednesday, June 10, 2009 7:59 PM
Points: 284, Visits: 92
Hello,
I have a SSIS package with a Data Flow task. This task transfers the data from excel to a table in SQL Server 2005.

I run this package on the Test Server it works fine.

then I modify data in the excel file and re-run the package again in test

But I get the error as below:

"The external metadata column collection is out of synchronization with the data source columns. The column "RPT DATE" needs to be updated in the external metadata column collection."

"The column "DOCKET" needs to be updated in the external metadata column collection."

doesn't it mean that I can't modify the excel file?

any solution on this?

Thanks,

Susan
Post #444131
Posted Friday, January 18, 2008 1:43 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Tuesday, March 18, 2014 4:41 AM
Points: 288, Visits: 301
It depends on how you change your excel sheet. I think SSIS scans the first 10 (or so) rows to determine the column data type. Say you have column A containing numeric values in these cells SSIS sets the DT_UI4 or so. If you change one cell to an alphanumeric value SSIS thinks the metadata has changed to DT_WSTR.
Post #444761
Posted Sunday, January 20, 2008 3:33 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Wednesday, June 10, 2009 7:59 PM
Points: 284, Visits: 92
I try different situation and it seems to me that I can't modify the excel file manually.
originally the file is coming from the result of exporting from other apps.

so I don't modify it and works fine.

Thanks everyone

susan
Post #445311
Posted Monday, March 30, 2009 8:02 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, February 12, 2010 6:14 AM
Points: 1, Visits: 9
Hi all,
i have a same Problem.
how can i fix the identificationstring?
thx
Post #686118
Posted Monday, March 30, 2009 8:08 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 11:23 AM
Points: 5,047, Visits: 11,799
What do you mean by "identification string"?

Are you modifying only data, or are you adding, renaming or deleting columns in Excel?



Help us to help you. For better, quicker and more-focused answers to your questions, consider following the advice in this link.

When you ask a question (and please do ask a question: "My T-SQL does not work" just doesn't cut it), please provide enough information for us to understand its context.
Post #686127
Posted Wednesday, November 17, 2010 3:36 PM


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Monday, August 25, 2014 11:53 AM
Points: 361, Visits: 1,169
I found this online today

http://social.msdn.microsoft.com/Forums/en-US/sqlintegrationservices/thread/8e3990bf-be08-418e-8c3f-60047cf5fda7/



¤ §unshine ¤
Post #1022517
Posted Friday, July 6, 2012 9:15 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, August 28, 2014 10:41 AM
Points: 1, Visits: 147
I deleted and added columns to an excel file, am using an excel source task, and I am getting this message. When I click on the Excel source, I get no message regarding an option to fix anything. When I add the external columns through the advanced editor, they are deleted the next time I try to go into it. Then I get the same message as before about columns out of sync.


I don't want to delete the task and then recreate it, but that might be the only way.

Also, the article from the last post does not help because the whole problem is the task is not fixing the errors and there is no way to force it as far as I can tell.

I have a destination table with more columns than are in my Excel worksheet. These are problem columns.
Post #1326161
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse