SQL Server Performance

Changing excel destination meta data

Discussion in 'SQL Server 2005 Integration Services' started by sqldev, May 22, 2007.

  1. sqldev New Member

    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
  2. satya Moderator

Share This Page