Not able to read the data (from schedule/agent) from design works fine

More

6 months 3 weeks ago #22429 by jerphaaskempke

Not able to read the data (from schedule/agent) from design works fine was created by jerphaaskempke

Hello,

In the design modus the transformation works fine. But when i use schedule i receive a warning (see screenshot)

Can you please help me?

Attachments:

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

More

6 months 3 weeks ago #22430 by admin

Replied by admin on topic Not able to read the data (from schedule/agent) from design works fine

Sure

We are always happy to assist.

Can you post a screenshot of the SQL server connection dialogue please?

Similar to this one

www.etl-tools.com/wiki/aetle/connections/database/sql_server

Mike
ETL Architect

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

More

6 months 3 weeks ago #22431 by jerphaaskempke

Replied by jerphaaskempke on topic Not able to read the data (from schedule/agent) from design works fine

see screenshots

Attachments:

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

More

6 months 3 weeks ago #22432 by admin

Replied by admin on topic Not able to read the data (from schedule/agent) from design works fine

We would like to connect remotely and investigate.

Please send an email to support@etl-tools.com

Mike
ETL Architect

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

More

6 months 3 weeks ago #22433 by jerphaaskempke

Replied by jerphaaskempke on topic Not able to read the data (from schedule/agent) from design works fine

The admin solved the problem.

Fixed with a system DSN instead of user DSN

The following user(s) said Thank You: admin

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

More

6 months 3 weeks ago #22434 by admin

Replied by admin on topic Not able to read the data (from schedule/agent) from design works fine

Thank you,

Please also set the user name for the agent service as described here.

www.etl-tools.com/wiki/knowledgebase/understanding_scheduler

Mike
ETL Architect

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