I have created this blog to learn more and more about SSIS and Sql server.
Here you will find posts about Control Flow Task, Data flow transformation and lot more. I have tried to explain transformations and tasks through simple scenario and example.
I hope this would help you

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