Stored Procedure Stage - Load issue

[senthilt1]

Hi All,

Am using the Stored procedure stage to load my sql server at the target end. When i execute the job it executes fine for 5000 records. When the records crosses 5000 the job aborts with the error message

" Communication link Failure" Sql State 08S01

Please let me know how to resolve this issue.

Thanks,

Senthil Kumar P

[chulett]

First thought would be to double-check the procedure. What exactly does it do? What is your job design? We'd need much more information to be able to help in any kind of meaningful way.