DT_WSTR Length Problem
Hi I am exporting data from SQL to Excel, So i used Excel destination, data conversion and Mapped DT_WSTR(4000) datatype for that particular column, but column having more than 5000 characters , So it is asking me to like ''Truncation may be due to inserting data from data flow coulmn to...." So this is the case what we have to do please help me
November 29th, 2011 9:04am

Did you try with DT_NTEXT data type ??Shailesh, Please mark the post as answered if it answers your question.
Free Windows Admin Tool Kit Click here and download it now
November 29th, 2011 9:13am

If you are not concerned about the truncation you can use SUBSTRING on the column. I'd like to know for sure what you are requesting help with though. Attempt to gather the entire 5000 or truncate the value to fit in the 4000? have you thought of options such as cutting the column with SUBSTRING and placing it into merged cells or something such as that? Throwing ideas out there for you given the little information providedTed Krueger Blog on lessthandot.com @onpnt on twitter Please click the Mark as Answer button if a post solves your problem!
November 29th, 2011 9:15am

Modify the data type to at excel to Memo and use data conversion task to put DT_NTEXT in excel.
Free Windows Admin Tool Kit Click here and download it now
November 29th, 2011 9:21am

Modify the data type to at excel to Memo How we can do it in Excel ?
November 29th, 2011 9:38am

Yes..when i am running from it server i am getting the below error Description : SSIS Error Code DTS_E_OLEDBERROR, An Oledb Has Occured Error code : 0x80040E21 Description : can not create an oledb acesseor.verify the coulmn metadata is valid Error Code : 0xC0202025 Description : component Excel destination 130 failed the pre excute phase and return error code 0xC02025
Free Windows Admin Tool Kit Click here and download it now
November 29th, 2011 9:38am

one way is to build the excel tab from within ssis, use exec sql task, point the data source to excel connection and execute a create table on the particular excel file. and use the data type is Memo where ever the length is exceeding 255 characters, for rest keep longtext.
November 29th, 2011 9:43am

when i am running pacakage from server i am getting the below error Description : SSIS Error Code DTS_E_OLEDBERROR, An Oledb Has Occured Error code : 0x80040E21 Description : can not create an oledb acesseor.verify the coulmn metadata is valid Error Code : 0xC0202025 Description : component Excel destination 130 failed the pre excute phase and return error code 0xC02025
Free Windows Admin Tool Kit Click here and download it now
November 29th, 2011 9:50am

My Client want to see full data
November 29th, 2011 10:04am

Yes..when i am running from it server i am getting the below error Description : SSIS Error Code DTS_E_OLEDBERROR, An Oledb Has Occured Error code : 0x80040E21 Description : can not create an oledb acesseor.verify the coulmn metadata is valid Error Code : 0xC0202025 Description : component Excel destination 130 failed the pre excute phase and return error code 0xC02025
Free Windows Admin Tool Kit Click here and download it now
November 29th, 2011 5:03pm

Hi prateep reddy, Please refer to the following simlar threads: http://www.sqlservercentral.com/Forums/Topic860660-147-1.aspx http://www.bidn.com/forums/microsoft-business-intelligence/integration-services/966/ssis-clarification-loading-data-from-db-to-excel If you have any question, please feel free to ask. Thanks, Eileen Forum Support Please remember to mark the replies as answers if they help and unmark them if they provide no help. If you have feedback for TechNet Subscriber Support, contact tnmff@microsoft.com.
December 1st, 2011 3:23am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics