I have a problem that seems to be linked with DB2Connect.
I created a MS DTS (Microsoft Data Transaction Services) package with SQLServer.
That package imports data from a SQL Server database, and delete/insert into DB2 database.
I created the package on my computer (Win2000 Pro SP4,SqlServer2000 SP3a,DB2Connect 7.1.3)
When I run the package all works fine (4 steps: delete from tableA,Insert in tableA, delete from tableB, insert in tableB)
The same package fails when runing from a NT Server (Win2000 SP4,SQLServer 2000 SP3a, DB2Connect 7.1.10)
The delete steps are working, but both insert steps give me:
Error Description:Insert error, column 2 ('MO', DBTYPE_I4), status 9: Permission denied.
I then installed DB2 FixPack 11 (7.1.11) , and I now get the same result from My PC. (I did execute the package just before patching and it worked)
Would anyone have a clue of what might cause the problem?
PS: more details/Points on MS SQL Groups: http://www.experts-exchange.com/Databases/Microsoft_SQL_Server/Q_20938448.html