We are setting a simple SSIS package to export table dd with 2 columns (int, nvarchar(256)) and 125M rows to Excel and when we try to create Excel destination editor and click new on "name of the excel sheet" it pop up the following table: CREATE TABLE `dd` ( `id` INT, `dd1` NVARCHAR(256) ) and when we click ok then get error message :Table cannot be created, Size of the field dd1 too long(Microsoft access database engine) Do we have any limit in size of field in excel column and how to resolve the issue? Also do we have any limit on number of rows that can be exported to Excel adapter?

Yes, even though Excel can accept textual data longer than 32,767 chars they will remain hidden. I do not see how you exceed the limit though, thus instead of creating it on the fly try making the output to an already ready sheet. I suspect the issue may be with the Unicode column dd1, Excel's driver has no Unicode supportArthur My Blog

Problem was that excel have limit of 255 for char columns so I needed to use MEMO datatype and export work fine. Now the problem is that we have not null column exported but one of the value is ' ' and even though it is not null for SQL Server but during import it is failing, Is there any way we can keep the ' ' and ' ' values during export/import so they are not treated as null? Another question is do we have any limit on number of rows that can be exported to excel?

You can have a Derived Column Transformation added with an expression that replaces the ' ' (single space?) with no space (empty string) E.g. REPLACE(Column0,"' '","") The max number of rows is version dependent 97-2003: 65,536 rows 2007: 1,048,576 rows Arthur My Blog