which is the best the best source and destination in both Sqlserver Source/destination and Oledb Source/Destination

Question

1.00/5 (1 vote)

See more:

My question is

we are designing packages in (SSIS)Sqlserver Integration Services using Source and Destination Adapters to pull the data into target systems.

if we want to full the Sqlserver table data into Sqlserver databases then
we are most of time using Oledb Source/Destination adapters instead of using
Sqlserver Source/Destination adapters

why were we using Oledb source and Oledb destination ?
can you please give me anybody detail answer............

Posted 5-Aug-13 19:32pm

Madhu from Bangalore

Add a Solution

Comments

Thanks7872 6-Aug-13 1:47am

omg...I dont even able to answer why you are working with this project? There is nothing to answer,really.

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Code-Hunt · Answer 1 · 2013-08-05T19:35:00

Solution 1

Oledb destination[^]

Oledb Source[^]

Check the links..hope it will help..

Posted 5-Aug-13 19:35pm

Code-Hunt

Mubin M. Shaikh · Answer 2 · 2013-09-04T00:25:00

Hi Madhu,

As per Microsoft guideline, IF your destinations is always going to remain same (SQL Server) then it is advisable to use sql server as destination from tool box, it will give you better performance then oledb destination.

if your destination changed to somewhere else on some other server type(e.g oracle) at that time you need to change your destination type(e.g. from sqldestination to oledb destination, it means you have to do rework, only connection string change will not work if you have sql server as destination type.

In this case OLEDB Destination will be benifited if your server type changes, then you only need to change server connection string in your dtsconfig file.

Regards,
Mubin