I'm new to iSM. I want to run a data migrator job from iSM. When I'm trying to configure the ETL object in iSM, i'm getting this error(please see print screen image).
Does anyone know that if I need to setup something before I can start using the ETL object in iSM?
This message has been edited. Last edited by: Shirley,
Shirley Huang WF 7.7.04M MRE BID DevStudio WIN2003, SQL Server 2000/DB2 HTML/PDF/EXL2k/AHTML iSM 6.16
October 04, 2012, 10:20 AM
Clif
This error occurs because Service Manager is attempting to invoke a stored procedure called EDAEXEC to issue commands on the DataMigrator server instead of executing them directly.
For security reasons this procedure is disabled. To enable it, please go to (by default) c:\ibi\srv77\home\catalog directory and rename edaexec.dat as edaexec.fex.
N/A
October 05, 2012, 05:13 PM
Shirley
Hi Clif,
Thanks. It's working now.
Cheers,
Shirley Huang WF 7.7.04M MRE BID DevStudio WIN2003, SQL Server 2000/DB2 HTML/PDF/EXL2k/AHTML iSM 6.16