Friday, 12 September 2014

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.