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: 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:
In 4th snapshot, one can also provide the connection string
instead, if the connection string is in some file.