- Posts: 3
- Thank you received: 0
Command Line Interface - not able to run a package from the command line
- bildungscenter
- Topic Author
- Offline
- New Member
-
Less
More
6 years 1 week ago #17159
by bildungscenter
Command Line Interface - not able to run a package from the command line was created 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
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
Please Log in or Create an account to join the conversation.
6 years 1 week ago #17160
by admin
Mike
ETL Architect
Replied by admin on topic Command Line Interface - not able to run a package from the command line
The issue you are having is related to regional settings (datetime format).
We will investigate it and get back to you
We will investigate it and get back to you
Mike
ETL Architect
Please Log in or Create an account to join the conversation.
6 years 1 week ago - 6 years 1 week ago #17161
by admin
Mike
ETL Architect
Replied by admin on topic Command Line Interface - not able to run a package from the command line
Mike
ETL Architect
Last edit: 6 years 1 week ago by admin.
Please Log in or Create an account to join the conversation.
- bildungscenter
- Topic Author
- Offline
- New Member
-
Less
More
- Posts: 3
- Thank you received: 0
6 years 1 week ago #17162
by bildungscenter
Replied by bildungscenter on topic Command Line Interface - not able to run a package from the command line
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
Best regards
Eldet
Please Log in or Create an account to join the conversation.
6 years 1 week ago #17163
by admin
Mike
ETL Architect
Replied by admin on topic Command Line Interface - not able to run a package from the command line
The solution is very simple
Create a separate user and use it for repository connection only
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.