external metadata column

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » SQL Server 2005 Integration Services » external metadata column

external metadata column

Rate Topic

Display Mode

Topic Options

Author

Message

Susan S

Posted Wednesday, January 16, 2008 10:25 PM

SSC 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

Alexander G.

Posted Friday, January 18, 2008 1:43 AM

SSC Veteran

Group: General Forum Members
Last Login: Wednesday, January 23, 2013 8:57 AM
Points: 287, Visits: 286

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

Susan S

Posted Sunday, January 20, 2008 3:33 PM

SSC 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

dipta3

Posted Monday, March 30, 2009 8:02 AM

Forum 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

Phil Parkin

Posted Monday, March 30, 2009 8:08 AM

SSCarpal Tunnel

Group: General Forum Members
Last Login: Yesterday @ 5:12 AM
Points: 4,226, Visits: 9,458

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:

http://www.sqlservercentral.com/articles/Best+Practices/61537/

If you are asking for help and your post does not contain a question, you should expect responses which do not contain any answers. Put a question mark in there somewhere - it's not rocket science.

Post #686127

sunshine-587009

Posted Wednesday, November 17, 2010 3:36 PM

Old Hand

Group: General Forum Members
Last Login: Yesterday @ 12:47 PM
Points: 360, Visits: 1,072

I found this online today

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

¤ §unshine ¤

Post #1022517

Mark-384086

Posted Friday, July 06, 2012 9:15 AM

Forum Newbie

Group: General Forum Members
Last Login: Friday, August 31, 2012 10:23 AM
Points: 1, Visits: 133

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 »

Permissions