Ssis-948
UX & Configuration
| Action | How to Perform | |--------|----------------| | Open the Connection Manager UI | Right‑click the manager → . | | Test Connection | Click Test Connection – should return “Connection succeeded”. | | Review the Connection String | Look for missing quotes, escape characters, or wrong provider name. | | Confirm Authentication | Windows vs SQL authentication – validate credentials. | | Check RetainSameConnection | Set to True if the component needs the same physical connection for multiple calls (helps with certain providers). | ssis-948
To minimize the occurrence of the SSIS-948 error and ensure smooth SSIS package execution: UX & Configuration | Action | How to