August 18, 2010 at 12:18 pm
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 18, 2010 at 12:20 pm
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 18, 2010 at 1:49 pm
Please enable logging in SSIS to get more details on the failure. Refer this
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply