Hi
@bestrongself
,
1.Please check if the connection manager can be tested successfully in SSDT.
2.Please check if the connection string was configured correctly.
3.Please create new connection manager.
Best Regards,
If the answer is helpful, please click "
Accept Answer
" and upvote it.
Note: Please follow the steps in our
documentation
to enable e-mail notifications if you want to receive the related email notification for this thread.
Hi
@bestrongself
,
1.Please set the
Delay Validation
as
True
in the properties of OLEDB Connection manager.
2.Please set the
ProtectionLevel
as
EncryptAllWithPassword
in SSIS package.
Best Regards,
If the answer is helpful, please click "
Accept Answer
" and upvote it.
Note: Please follow the steps in our
documentation
to enable e-mail notifications if you want to receive the related email notification for this thread.