Page 1 of 1

PLS-00123: program too large (Diana nodes)

Posted: Tue 04 May 2010 14:49
by bhav27
Hi
I get above error when my SSIS package tries to insert 1800 + records into the database. Does anyone have a clue to this problem?

Posted: Wed 05 May 2010 14:53
by bhav27
I solved this problem by setting the batch size to 200

Posted: Thu 06 May 2010 09:23
by StanislavK
This is the expected error for SSIS inserting a large batch. Glad to see that the problem was resolved.