Command Line Interface - not able to run a package from the command line

More
6 years 1 week ago #17159 by bildungscenter
Dear ETL-tools Team,

I have a problem with the command line interface. A package works fine within the Advanced ETL Processor Enterprise GUI. But I am not able to run the same package from the command line. There is a error message - see screenshot. Can anyone help me with this problem?

Application Name: Advanced ETL Processor Enterprise 32Bit
Version number: 6.0.0.13
Operation system version: Small Business Server 2003 (I know it is old)
Database version MS SQL 2005
Repository type MS SQL

See attached screenshot command line interface and overview package.

Thank you!

Best regards
Eldet
Attachments:

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

More
6 years 1 week ago #17160 by admin
The issue you are having is related to regional settings (datetime format).
We will investigate it and get back to you

Mike
ETL Architect

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

More
6 years 1 week ago - 6 years 1 week ago #17161 by admin
Can you tell us what is the language setting for the user you connect to the repository.


Mike
ETL Architect
Attachments:
Last edit: 6 years 1 week ago by admin.

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

More
6 years 1 week ago #17162 by bildungscenter
Thank you for your hint! I checked the language setting for the user connecting to the repository SQL database. It was German. I changed it to English and now the command line interfaces works fine. I am not sure, if there might be any problems if I change permanently the language setting to English. Because we are using several (german) programs with SQL database access. Is there any another solution - e.g. starting aetlcl.exe with some parameters or autodetect language?

Best regards
Eldet

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

More
6 years 1 week ago #17163 by admin
The solution is very simple
Create a separate user and use it for repository connection only

Mike
ETL Architect
The following user(s) said Thank You: bildungscenter

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