ExcelSource file – metadata validation

5 pts.
Tags:
Excel Metadata
Microsoft Excel
SQL tables
SSIS
I need some assistance. I am using an excel file to import data to SQL tables. The problem I am running into is having to replace the metadata of the output columns with the metadata of the external columns. I do not want to do this manually everytime. [The metadata of the following output columns does not match the metadata of the external columns with which the output columns are associated: Output "Excel Source Output": "<Column1>",<Column2>" Do you want to replace the metadata of the output columns wit the metadata of the external columns?] The excel file that I import, changes periodically. For example, I have five columns where the data in one of the columns may be less than 255 characters and then another time greater than 255 characters. I have attempted to use the Advanced Editor for Excel Source and change the Input and Output Properties to say Ntext to allow for greater than 255. Unfortunately evertime the data changes and is less than 255 characters the Input columns will change and reflect the 255 character length or Unicode string [DT_WSTR]. How can I keep the Input and Output properties from changing? How can I keep from having to validate the metadata evertime. I have also tried to turn the validate metadata option to false and still does not work. Data conversion does not work. I receive the error: falied to retreive long data for columns "<column1>. Please advise.
ASKED: December 5, 2008  4:44 PM
UPDATED: December 5, 2008  5:36 PM

Answer Wiki

Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following