Scheduled DTS task to import data from Informix 7.2 not working

[turtledisc]

Hi,

I've created a DTS package to import data into SQL server 2000 from Informix 7.2. I'm using the Informix Client SDK ODBC 2.81. The DTS task works when I run it manually but gets an "Unable to load translation dll" when it runs as a scheduled job. I've checked the INFORMIXDIR and it all looks correct. Does anyone have any ideas?

Thanks,

Jacquie

Jacquie Kelly

 

[mutley1]

Hi Jacquie,

This "might" help...

http://p2p.wrox.com/topic.asp?TOPIC_ID=1071

HTH,

M.

 

[turtledisc]

Hi Mutley1,

I've checked all of the settings suggested in that link and as far as I can see it's all set up correctly. I'm thinking of rebooting the SQL Server server just to be on the safe side.

Thanks,

Jacquie

Jacquie Kelly

 

[turtledisc]

Just a quick update - it started working after the reboot of the server.

Jacquie Kelly