Error Code | 27 |
Error Message | Error writing File - Closing Command Object. |
Description | For excel connectors to initialize new sheet Before transformation event is required. This error is usually displayed for connectors like Excel 2007, Excel 2010, and Excel xlsx. |
Cause/Solution | Cause: Microsoft Excel supports 1,048,576 rows and 16,384 columns. Solution: You can write 1,048,576 rows at a time: 1. Click the Configuration Tab. 2. Expand “Map Events”. 3. Add “TransformationStarted” map event. 4. Add Table operation Drop and create. 5. Run the transformation. |
Related Information |