SSIS: OleDb Connection and ADO.NET Connection

Quick View on OleDb Connection and ADO.NET Connection

Both Oledb and ADO.NET connection can be created in the same manner, as shown below:

  

                             1                                                        2

                                                                  

     

3                                                            4

In 4th snapshot, one can also provide the connection string instead, if the connection string is in some file.

For all other connection click on below links,
Flat File Connection
File Connection
Connection from Data source
New Connection