command line error

More
5 years 5 months ago #17799 by apmancini
command line error was created by apmancini
Advanced ETL Processor Enterprise
Version : 6.3.0.5

I have a Transformation which uses a Google Spreadsheet source and an ODBC target. Runs fine in the IDE. However when running at the command line with aetlcl.exe and passing the object id - we get - "Cannot open file : DesktopConnection.ini - system cannot find the file specified."

What is it looking for?

Please Log in or Create an account to join the conversation.

More
5 years 4 months ago #17800 by admin
Replied by admin on topic command line error
Go into
C:\ProgramData\ETL-Tools.com\Repository

Find ServerConnection.ini make a copy of it and call it DesktopConnection.ini.

Can you tell me why you are not using execution agent?

You do have enterprise version so you should be using execution agent.

Mike
ETL Architect

Please Log in or Create an account to join the conversation.

More
5 years 4 months ago #17801 by apmancini
Replied by apmancini on topic command line error
I don't want non-Admin users using the ETL software directly to run their Transformations on demand. For those cases I use an external scheduler executable task which they can run from a client on their desktops...

Please Log in or Create an account to join the conversation.

More
5 years 4 months ago #17802 by admin
Replied by admin on topic command line error
Perhaps they can use management console?

I am just thinking how we can make our software satisfy your needs better.

We are open to suggestions

Mike
ETL Architect

Please Log in or Create an account to join the conversation.