Troubleshooting > Troubleshooting DataConnect > Error writing file or closing command object
Was this helpful?
Error writing file or closing command object
 
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
Last modified date: 07/26/2024