- 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 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.