Hi , Im wokring on an SSIS Project which loads data froma stored proc and creates an Excel File, I have to drop and recreate the Excel Table where if I dont it appends. The issue Im having is that the stored proc has a field1 of nvarchar 256 which when I try to load Excel connection manager will not allow creation of long columns i.e 256, and it fails [Execute SQL Task] Error: Executing the query "CREATE TABLE `ReconReport` ( `Fun....." failed with the following error: "Size of field 'Tranch' is too long.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly. when I modify it to 255 it keeps on giving me a warning as below, as ofcorse it would , how can I get ri of this warning without making changes to the sp [Excel Destination [1028]] Warning: Truncation may occur due to inserting data from data flow column "Tranch" with a length of 256 to database column "Tranch" with a length of 255. Please let me know if anyone is aware of this issue.

Well, based on what I see you create a workheet in Excel file using SQL, right? But you need to define this column as memo in Excel to allow it accepting more than 255 chars.Arthur My Blog

I was able to get rid of this warning by a DataConversion Thanx:)