August 16, 2010 at 10:28 am
Hi
I am actually new to SSIS, There is a package already deployed in the prod server which runs perfectly fine each time
But here is the problem.. the package actually has to be executed once for every 10 minutes
It worksfine for 9 times but 10th time its droping.. and if i leave it for some time and redo it its fine.
The package is huge though... It has several script tasks and other tasks.
What can i do to rectify this..plz help..
August 17, 2010 at 6:05 am
This was removed by the editor as SPAM
August 18, 2010 at 9:18 am
SSIS ERROR MESSAGE --> Package: Master_JDProductionUploads was executed at: 7/31/2010 3:20:01 PM by user: GCC\srvSqlSSISPkg on Machine: GCCRMDETL1
Task Name: Map AccessDb1 PC to Drive T Script Task Error Code: 8 Error Desc: The script returned a failure result. Start Time: 7/31/2010 3:20:02 PM Error Log ID: -1 Return Value: -1
August 19, 2010 at 12:00 am
This was removed by the editor as SPAM
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply