Tuesday, April 30, 2013

SSIS: New connection

New connection

Apart from the connection manager like oledb, flat file, file connection, ADO.Net, connection from data source. There are other connections also available, which can be created by select New Connection in Connection manager, which will pop up a window as below. Now any kind of connection mentioned can be created.

Enjoy going through all the connection.  Especially the MultiFile and MultiFlatFile connection, through which, we don’t need to create multiple connection to flat file or files. It’s Awsome! J

For all other connection click on below links,
OleDB and ADO.Net Connection
Flat File Connection
File Connection
Connection from Data source

Please provide your feedback for the post, if you find this post useful. Also Post your query or scenario, i will be happy to help.

No comments:

Post a Comment