What's your DSN setup look like (for iSeries connection)?


phantomtoe@yahoo.com (Rowan) wrote in message news:<4bbf8d70.0404061235.5e1e3334@posting.google. com>...
> Hello, I have been trying to solve this problem for a couple of weeks
> now with no progress. I created a package that works when it runs
> from my computer but when it runs as a scheduled job, it fails. I
> found references to this quite a few times and the responses have
> always pointed to permissions, but I am a System Administrator. My
> role is Sysadmin. I changed the Windows/NT owner of the job to sa and
> that didn't work either. I made sure that the account that runs from
> SQL Server has Sysadmin permissions.
>
> The problem I think has to do with the AS400 connection that I make to
> pull data out of the AS400 to put into SQL Server 2000. In the
> Connection of the package there is a place for User and Password. I
> had the person who definitely has all Rumba permissions put his
> username and password in there and it came back with the same error.
> The Error message is below. I am sure at a loss. Does anyone have
> any ideas? I would really appreciate anything. Could this have
> anything to do with MDAC?
>
> DTSRun: Loading... DTSRun: Executing... DTSRun OnStart:
> DTSStep_DTSExecuteSQLTask_1 DTSRun OnFinish:
> DTSStep_DTSExecuteSQLTask_1 DTSRun OnStart:
> DTSStep_DTSDataPumpTask_1 DTSRun OnError:
> DTSStep_DTSDataPumpTask_1, Error = -2147467259 (80004005) Error
> string: [Wall Data][RUMBA Data Access][RUMBA95]Communication link
> failure. APPC Primary RC = Parameter_Check; Secondary RC =
> Bad_LU_Alias. Error source: Microsoft OLE DB Provider for ODBC
> Drivers Help file: Help context: 0 Error Detail
> Records: Error: -2147467259 (80004005); Provider Error: 0 (0)
> Error string: [Wall Data][RUMBA Data Access][RUMBA95]Communication
> link failure. APPC Primary RC = Parameter_Check; Secondary RC =
> Bad_LU_Alias. Error source: Microsoft OLE DB Provider for ODBC
> Drivers Help file: Help context: 0 DTSRun OnFinish:
> DTSStep_DTSDataPumpTask_1 DTSRun: Package execution complete.
> Process Exit Code 1. The step failed.