July 7, 2010 at 10:22 pm
Hi Guys,
my objective is to use SSIS ,use its Data flow task and import columns of a .csv file (Flat File Source) to a table in SQL Server 2005. Now, I was having problems with the destination. Initially I used SQL Server Destination and got errors 0x80040E14. Later after reading blogs, I changed the destination to OLE DB destination and works fine.
Now, objectives are the same, but I don't understand the difference. And importantly, how does an OLE DB destination change something like an object/attribute in SQL Server?
My knowledge is very limited, as I am newbee in SQL.
Thanks in Advance 🙂
July 8, 2010 at 4:51 am
As for my Knldge
Yes there is difference b/w SQL Server Destination and OLE DB destination,if u want load the data in different DB u can use OLEDB,when u loading the data only to SQL u can use SQL destination,in OLEDB u have bulk insert option but in sql u have only one option table or view,performance wise SQL destination was good
July 8, 2010 at 5:03 am
Also, you can only use SQL destination when you are running your package on the same server as your destination.
It is a whole lot quicker than the OLEDB destination
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply