Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
collie
Constraint Violating Yak Guru
400 Posts |
 Posted - 2012-02-05 : 11:25:17
|
| Hi,I am still not able to understand which SSIS source/destination to use with SQL server 2005- ADONET,OLEDB OR SQL SERVER DESTINATION.Can someone please explain in layman's words?Thanks |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-02-05 : 11:28:17
|
| sorry question is not clearIf you want to pull data from or push data to SQL Server, then you can use OLEDB destination or SQL Server Destination.SQL Server destination can be used only if SSIS is running in the same server in which SQL DB residesOLEDB can be used to connect to any SQL Server destination whether or not in the same machine------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
collie
Constraint Violating Yak Guru
400 Posts |
Posted - 2012-02-05 : 15:35:26
|
| Hi,I meant when will you use when over the other. Why would you use adonet source/destination as opposed to ole db?Thanks |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-02-05 : 15:53:22
|
| ado net is used for connection to dbs which support ado connectivity like MySQL or even to connect directly to ado recordsetsdifference b/w OELDB and sql server destination is what i suggested earlierSQL Server destination can be used only if SSIS is running in the same server in which SQL DB residesOLEDB can be used to connect to any SQL Server destination whether or not in the same machine------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
|
|
|
which source/destination to use