external metadata column

Question

external metadata column

Susan S

SSCommitted

Points: 1771
More actions
January 16, 2008 at 10:25 pm

#119621

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

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

Alexander G. SSCrazy Points: 2705 More actions · Answer 1

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.

Susan S SSCommitted Points: 1771 More actions · Answer 2

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

dipta3 Valued Member Points: 57 More actions · Answer 3

Hi all,

i have a same Problem.

how can i fix the identificationstring?

thx

Phil Parkin SSC Guru Points: 246965 More actions · Answer 4

What do you mean by "identification string"?

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

The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin

sunshine-587009 SSCrazy Eights Points: 8981 More actions · Answer 5

I found this online today

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

¤ §unshine ¤

Mark-384086 Valued Member Points: 59 More actions · Answer 6

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.