Unfortunately changing the connection type is not an option in my organization - thank you for the suggestion though

Hello,
Did anyone find a solution to this problem - I am experiencing the same issue - the SSIS OLE DB Connection Successfully tests but in using a OLE DB...