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.

Creating a backup report on the report server prob.

Hi Everybody,

I hope that someone will be able to help me with that problem. I have a .rdl file on the server (report Server). Now I need to use this .rdl, make somes changes and create a new one on the same server in another directory.

Here are the codes that do all the work;

Dim streamData As New MemoryStream(rptDefinition)

Dim doc As XmlDocument = New XmlDocument()

doc.Load(streamData)

' do the changes process here

Dim rpt As Byte() = System.Text.Encoding.Unicode.GetBytes(doc.OuterXml)

Return rpt

I always got this error:

The report definition is not valid. Details: Name cannot begin with the '.' character, hexadecimal value 0x00.

How can I solve that?

Thanks

Hi,

I would check two things:

(1) The encoding you are using. The document might be using UTF-8, not unicode.
(2) The byte order mark. Check if the first two bytes of the array are [239] [187] (In decimal viewed through the debugger). If so remove these before returning the array.

-JonHP (MSFT)

|||

Hi JonHP,

It works now. I just replaced the unicode encoding with the UFT8.

Thanks a lot.

create word document from rdl-file

Hi everybody,

I'm looking for a tool or template that creates a good looking document from the rdl-files.

I need it for internal documentation.

Can you help me?

Gerd

Wrong forum. Try the Reporting Services forum.

-Jamie