• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 738
  • Last Modified:

SSIS IBMDA400 driver error

Hi,
I've got an SSIS job which uses a IBMDA400 connection to our AS400 server.
The package runs fine in VS2008 on a XP or Windows 7 workstation but not on the Windows 2003 server.
The error in the SQL server history is:
"
The PrimeOutput method on component "Get iSeries Data" (1) returned error code 0xC0202009.  The component returned a failure code when the pipeline engine called PrimeOutput(). The meaning of the failure code is defined by the component, but the error is fatal and the pipeline stopped executing.  
"
Any ideas?
Thanks,
Mark
0
HoppaRoppa
Asked:
HoppaRoppa
  • 3
1 Solution
 
HoppaRoppaAuthor Commented:
Hi,

The trouble with that is I will need to redevelop the whole project and the .Net Provider does not allow me SQL Command From Variable and I need this as we have multiple data libraries for different test systems and I don't want to have to change the packages every time I deploy it to a different environment.

It is working fine running on my Windows 7 machine  and my collegues XP machine, its just when we deploy it to the system test server Windows 2003 with SQL 2008.

Any other suggestions would be appreciated.

Thanks,
0
 
HoppaRoppaAuthor Commented:
Hi,

I have solved this issue. The problem was with the IBM Driver Version (V5R3), I upgraded this to V5R4 and the issues have been resolved.

Thanks,

0
 
HoppaRoppaAuthor Commented:
Checked the Client Access Version on the machine running SSIS and noticed that it was a release behind, after updating it, the issues were resolved.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now