Advantage of ADO.net destination over OLEDB destination SSIS?
i am trying to load data from text file to sql server table.
what is the pros and cons of using ado.net DF destination over oledb DF destination?
~Sr. Database Analyst~
June 29th, 2011 4:24am
I don't see any pro.
.net Destination is good, if the destination is for example an ODBC-Destination.
For SQL Server as a Destination I always suggest OleDB Destination.
Free Windows Admin Tool Kit Click here and download it now
June 29th, 2011 5:27am
No Advantage! Always use OLE DB Destination, it's safer.http://thebipalace.wordpress.com
June 29th, 2011 9:02am
Refer to this thread for similar discussion and answer
http://social.msdn.microsoft.com/forums/en-US/sqlintegrationservices/thread/954acf53-3280-40d6-9630-7672911c7c48/
Sorry. The link mentioned in the post above is not working. Refer to this post for detailed answer.
http://social.msdn.microsoft.com/forums/en-US/sqlintegrationservices/thread/1a9e3670-9685-4943-913b-123ecf248a9c/
Venkataraman R
Free Windows Admin Tool Kit Click here and download it now
June 29th, 2011 9:26am