Creating connection manager in SSIS

Introduction:

• Creating a connection manager is the first step of creating a Package and is a very important part.
• After creating connections only we can do operations inside databases and files.

OLEDB Connection:

• OLEDB connection is required to do any operations inside a Database.
• Here we will be creating a OLEDB connection to a SQL Server.
• To create a connection manager go to the connection manager pan in a package.
• Right click on it and choose 'New OLEDB connection' option.

• Click on 'New'.

• Fill the Server information like Server Name, Authentication type, choose the Database and then click test connection.
• If all the information is correct you will get the following pup-up.

• Click OK and a new connection manager will be created inside the Connection manager Pan.