Ado net source fail to acquire connection
0
votes
0
answers
698
views
I have a SSIS package package that connects with azure sql database through using ADO net connection manager with SQLclient data provider. Authentication method used is Integrated security. The SSIs package executes fine through Visual studio 2019. However when executed through Autosys it fails. The error in log file says **Ado net source fails to acquire connection with error message : one or more error occurred.**
The job machine have .net 8 and .net framework 4.8. I searched over internet to find out that SqlClient data provider comes by default in .net framework. System requirements seems to be fine to me. What could be the reason
Asked by Agent SKY
(1 rep)
Jan 10, 2024, 03:54 AM