Data Warehousing and Data integration

Scheduling / Execution Agent Best Practices

More
4 months 2 weeks ago #22521 by admin
If you are stuck we can connect remotely and assist.

Also, we do not recommend using MS Access as Repository in the production
It tends to get corrupted over time.
.

Mike
ETL Architect

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

More
4 months 2 weeks ago #22531 by jchamberlin
Thanks for following up Mike and pointing me to the logs. When I started diving into them, I realized the issue was the service account didn't have the proper permissions to access the database I was querying from. Our security engineer took a look sorted everything out.

Thanks for all your help!
The following user(s) said Thank You: admin

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