Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


external metadata column


external metadata column

Author
Message
Susan S
Susan S
SSC Veteran
SSC Veteran (284 reputation)SSC Veteran (284 reputation)SSC Veteran (284 reputation)SSC Veteran (284 reputation)SSC Veteran (284 reputation)SSC Veteran (284 reputation)SSC Veteran (284 reputation)SSC Veteran (284 reputation)

Group: General Forum Members
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
Alexander G.
Alexander G.
SSC Veteran
SSC Veteran (289 reputation)SSC Veteran (289 reputation)SSC Veteran (289 reputation)SSC Veteran (289 reputation)SSC Veteran (289 reputation)SSC Veteran (289 reputation)SSC Veteran (289 reputation)SSC Veteran (289 reputation)

Group: General Forum Members
Points: 289 Visits: 315
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
Susan S
SSC Veteran
SSC Veteran (284 reputation)SSC Veteran (284 reputation)SSC Veteran (284 reputation)SSC Veteran (284 reputation)SSC Veteran (284 reputation)SSC Veteran (284 reputation)SSC Veteran (284 reputation)SSC Veteran (284 reputation)

Group: General Forum Members
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
dipta3
dipta3
Forum Newbie
Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)

Group: General Forum Members
Points: 1 Visits: 9
Hi all,
i have a same Problem.
how can i fix the identificationstring?
thx
Phil Parkin
Phil Parkin
SSCrazy Eights
SSCrazy Eights (8.3K reputation)SSCrazy Eights (8.3K reputation)SSCrazy Eights (8.3K reputation)SSCrazy Eights (8.3K reputation)SSCrazy Eights (8.3K reputation)SSCrazy Eights (8.3K reputation)SSCrazy Eights (8.3K reputation)SSCrazy Eights (8.3K reputation)

Group: General Forum Members
Points: 8322 Visits: 19470
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.

If the answer to your question can be found with a brief Google search, please perform the search yourself, rather than expecting one of the SSC members to do it for you.

Please surround any code or links you post with the appropriate IFCode formatting tags. It helps readability a lot.
sunshine-587009
sunshine-587009
Old Hand
Old Hand (365 reputation)Old Hand (365 reputation)Old Hand (365 reputation)Old Hand (365 reputation)Old Hand (365 reputation)Old Hand (365 reputation)Old Hand (365 reputation)Old Hand (365 reputation)

Group: General Forum Members
Points: 365 Visits: 1273
I found this online today

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

¤ §unshine ¤
Mark-384086
Mark-384086
Forum Newbie
Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)

Group: General Forum Members
Points: 1 Visits: 157
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.
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search