Creating a new Integration Service Component

Good morning everybody,

I made a Java application to pre-process portuguese texts (stopwords, stemming, BOW creating, etc.)

I want to transform this application on a Integration Service component. I understand I will have to code this new component from zero. But I have no idea on how to start.

I'm reading and testing several tutorials on Integration Services that came with the SQL Server install package but none of them has clues on developing new components. These tutorials seams more focused on demostrate the (awesome) capabilities of Integration Services.

Is there any tutorials on how to implement new components to Integration Services ?

Any help will be very appreciated.

Thanks a lot,

-Renan Souza

Hello, Renan

A few Integration Services Samples are available at codeplex : http://www.codeplex.com/MSFTISProdSamples

you might also want to check this out: "SQL Server Integration Services (SSIS) Hands on Training - Creating Custom Components" at http://www.microsoft.com/downloads/details.aspx?familyid=1c2a7dd2-3ec3-4641-9407-a5a337bea7d3&displaylang=en

Hope this helps

|||

Thanks a lot for your prompt reply.

It was very helpfull, as usual.

Create user.....

Hi.
i want to create a user which can communicate with the sql server 2000
through any third party application e.g VB, Java etc, but the user cannot
login dirctly on EM or query Analyzer.
ThankxxxMuhammad Bilal (MuhammadBilal@.discussions.microsoft.com) writes:
> i want to create a user which can communicate with the sql server 2000
> through any third party application e.g VB, Java etc, but the user cannot
> login dirctly on EM or query Analyzer.
That is not possible. But if the applicaiton relies on stored procedures,
all the user needs is EXEC permission on the procedures. If the application
uses embedded statements, the user will have to have full permissions,
unless the application uses application roles.
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx|||I suggest "googling" for the words "trusted subsystem". In a Trusted
Subsystem model, you create a service which performs all of the actions
on the database. This service (many times it's hosted in IIS) runs
under a normal account which has privileges to access the database, and
it is responsible for enforcing the security of your transactions.
But the real answer to your question is "you can't". There's nothing
special about SSIS, EM, QA, or even your VB/Java app. They all connect
and interact with SQL Server in very similar ways.
Muhammad Bilal wrote:
> Hi.
> i want to create a user which can communicate with the sql server 2000
> through any third party application e.g VB, Java etc, but the user cannot
> login dirctly on EM or query Analyzer.
> Thankxxx
>