Changing excel destination meta data | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Changing excel destination meta data

Hi, I am trying to upload data from a database table to excel application using SSIS. Here, one of my fields contain nvarchar 2000 characters. By default, excel application assumes 255 characters as the data length for every column invariably, this is its metadata. I am using OLEDB Source to Excel Destination to achieve this. Here, I could not change the metadata information for excel application, it gives runtime error during data upload and aborts the process. If I skip the error, data is not populated for that particular column. The following is the warning message, Warning: 0x802092A7 at GenerateErrorSpreadsheet, GenerateErrSpreadsheet [322]: Truncation may occur due to inserting data from data flow column "InvalidFields" with a length of 2000 to database column "InvalidFields" with a length of 255. Please help me to overcome this problem, thank you. Regards,
Devendran R
See thishttp://msdn2.microsoft.com/en-us/library/ms166566.aspx link is any help here. Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.
]]>