Hello there,
So I have a job which consists of 3 tasks; 1. SQL Task, 2. Excel Task Create, 3. Send Mail.
I'm getting an error with the 2nd task which is the excel create. It says, "Exception in Task: System.OutOfMemoryException: Exception of type 'System.OutOfMemoryException' was thrown."
Do we have any limitation rule when it comes to SQL and Excel writing? Seems like my SQL is returning too much rows.
Thank you,
rome