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 |
|
carumuga
Posting Yak Master
174 Posts |
 Posted - 2009-01-13 : 08:14:55
|
| Hi,Is there any difference between OLEDB Destination and SQL Server Destination in SSIS.Thanks in advance. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-01-13 : 08:55:01
|
| http://blogs.digineer.com/blogs/larar/archive/2006/08/20/385.aspx |
 |
|
|
Nagaraj
Starting Member
14 Posts |
Posted - 2009-01-15 : 03:58:27
|
| OLEDB destination loads the records in batches, where as SQL Server destination loads all the records at one go..Nagaraj. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-01-15 : 07:35:29
|
quote:
Originally posted by Nagaraj
OLEDB destination loads the records in batches, where as SQL Server destination loads all the records at one go..Nagaraj.
also more importantly SQL Server destination can be used only if destination db is on same server. |
|
|
|
|
|
|
OLEDB Destination vs SQL Server Destination