Schedule a DTS package Using OpenLink fails

[SueP]

Hi

We are trying to run a DTS package via a schedule to run once a day. The DTS package has a System DSN set up using OpenLinks Multi Tier ODBC setup version 4.20, which connects to a Progress Database - Progress 91c. We have set all the protocols and ports correctly as the DTS script runs fine Manually. However as soon as we schedule this package it fails on the first transfer task from the progress database.

We have checked the SQL server agent properties and the DTS properties to make sure the user and package has enough rights to be run and this is all fine. So I'm now stuck. Is there anything that is configurable within open link that I need to do to allow this package to be run via a schedule? I've read on MS that some third-party drivers do not support free threading - but I belive open link does and that we have set for each task etc execute on main package Thread to be true.

The error we get from SQL is :-
Step Error Source: Microsoft Data Transformation Services (DTS) Package
Step Error Description:Catastrophic failure
Error code: 80040428
\Error Help File:sqldts80.hlp
Error Help Context ID:700

Anyone got any ideas?

Many thanks
Sue

 

[murLee]

progress plus DTS

Can you Explore more things about procedure of DTS with progress becoz we Are also using DTS For importing journal and CF database into sql server from Progress using CCure software. how you are using DSN in DTS?

 

[Casper]

Hi,

80040028 means: The current request processor does not support the request.

Have you tested connection with progress database and openlink?
How do you connect to the progress database? Do you use OIB or sql broker?

Check your sql statements and maybe first try it with a simple statement like select * from pub.table;


Regards,

Casper.

Oops, answer to old post... ;-)