April 18, 2014 at 3:14 am
Hi,
I am facing issues and unable to resove it. We made SSIS package in dev environment in windows 2008R2 and SQL server 2012. Same packages were placed on SAN disks in cluster environment and are invokded with security contexxt of admin user and wih dtexec utility ( we call this using an sp). rarely but procedure completed i see the log text file by SSIS package and find the reqturn code 5 means package is unable to load. Googling i cannt found what are the exact reasons for return code 5.
April 18, 2014 at 4:03 am
Can you post the exact error message?
Which version of SSIS are you using?
Be aware that SSIS in earlier versions is not cluster aware.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
April 21, 2014 at 4:49 am
Today again the same error occurred. There is no log.
SQL procedure was called which in turn calls SSIS package via dtexec utility.
But the error return code is 5 again.
version is sql server 2012.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply