Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2004
    Location
    Montgomery Village, MD
    Posts
    2

    Unanswered: 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...

  2. #2
    Join Date
    Dec 2002
    Posts
    1,245
    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
    Have you hugged your backup today?

  3. #3
    Join Date
    Oct 2004
    Location
    Montgomery Village, MD
    Posts
    2

    version..

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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •