SQL Server Integration Service (SSIS) 2016 - Create OLE DB Connection in SQL server

First you have to right click on the Connection manager window and select New OLE DB Connections.
Click on the New button.
Give the database connection details.
Test the connection.
Then you can see the OLE DB connection in the Connection manager window as below.

Thank you !!!
SQL Server Integration Service (SSIS) 2016 - Create OLE DB Connection in SQL server SQL Server Integration Service (SSIS) 2016 - Create OLE DB Connection in SQL server Reviewed by Pubudu Dewagama on 8:09:00 AM Rating: 5

No comments: