Showing posts with label residing. Show all posts
Showing posts with label residing. Show all posts

Friday, February 17, 2012

dts transform task failing when using IBM db2 odbc driver..

The thing is I am using a DTS package to get data from db2 residing on a s390-mainframe and put it in a sql 2000 db on windows 2000 server..

I have the odbc driver that the server guys gave me..I installed it and then run a batch pgm, which i think does the database set up...in short i set up the DSN's in my local machine..I can use the dsn when i use the sql client...

I can't create a new package and then complete the task..Problem is when i try set up a transform task, i get a memory error...it says that the instruction referenced a memory location that can't be read...

So what i do is i use the import task in sql...which inturn uses the same odbc connection and runs the query on db2..inserts the results into a table in sql..then save the package...Only problem is that i can't edit the transorm task...same memory error...

Any idea why this happens ?? I would like to see how i can get past this using Odbc...What version of the driver are you using? IBM posts hotfixes and patches on their website for their drivers; you may be able to find a fix for the one you are using.

In particular I remember a hotfix for their AS/400 V5R1 driver that fixed an issue I was having.

Regards,

hmscott|||think it is ==>
Version: 7, Release: 2, Modification: 3, Service Level: WR21254