Tuesday, April 30, 2013
SSIS: 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