10777 - 11Extending SQL Server Integration Services

Hello experts,

based on your experience I might discuss some real examples of implementation on:
-Custom Component
-Script Task: to implement a custom control flow task
-Script Component: to implement a custom data flow source, transformation, or destination
enrique_aeoAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Jim HornMicrosoft SQL Server Developer, Architect, and AuthorCommented:
Please rephrase your question so that it is an actual question.
0
enrique_aeoAuthor Commented:
Good morning,

Please support with examples of using these 3 items
-Custom Component
-Script Task
-Script Component
0
enrique_aeoAuthor Commented:
Need to understand the differences in order to choose the most suitable.
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

Jim HornMicrosoft SQL Server Developer, Architect, and AuthorCommented:
Please state for us your business requirements.
Currently it appears that you are asking us a homework question.
0
enrique_aeoAuthor Commented:
I need to read the users that are saved in the active directory to saved in an Oracle table
0
slightwv (䄆 Netminder) Commented:
I have no idea what the original question of:
-Custom Component
 -Script Task
 -Script Component

is asking about but the latest request:
I need to read the users that are saved in the active directory to saved in an Oracle table

Can be completed using DBMS_LDAP and some PL/SQL code.

See if the solution in this previously asked question provides what you are after:
http://www.experts-exchange.com/Database/Oracle/Q_28033140.html#a38893535
0
enrique_aeoAuthor Commented:
the tool that I use is: SSIS (sql server integration services)
0
slightwv (䄆 Netminder) Commented:
So, you want SSIS to load AD data into an Oracle database?

Seems overly complex.

You'll need to have SQL Server query AD and pass the information over to Oracle.

I'm not a SQL Server person so cannot provide a model to go by.

Until a SQL Server Expert shows up to this question,  I'm sure there are many examples out there on doing that if you look around.
0
enrique_aeoAuthor Commented:
In my work I say that in this first stage will be sufficient to record the information in a file. Csv
0
enrique_aeoAuthor Commented:
Finally the problem is:

Read information from the active directory and burn it to a text file using sql server integration services
0
slightwv (䄆 Netminder) Commented:
I suggest you take a look at the following link that describes how to query AD with SSIS:
http://social.technet.microsoft.com/wiki/contents/articles/1293.processing-active-directory-information-in-ssis.aspx
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.