Doubts On Integration Services

Good morning,

I've to do a mining project and I intend to use the SSIS.

I've done a clustering plugin last year on analysis services and I also want to use it.

Let me try to explain the architecture of the process:

1) Receive data (read data from the database - these data are texts, actually)

2) Pre-process the data (transform the texts in a sparse matrix) using a new plugin

3) Call my clustering plugin and assign it to read the table created on the previous step

4) Call my KNN plugin to classify other pre-processed texts using the clusters found on the previous step as classes.

5) Show results.

Alright... It all running as a workflow on integration services

Here are my doubts:

A) How to view and use my plugin made for Analysis Services on Integration Services ? (is it possible or will I have to create another plugins from zero just to run on Integration Services ?)


B) Assuming the previous step is possible, how to modify my plugins to define inputs and outputs to do the correct communications between each plugin ? I think this is the most important question. Is it simple to do ? Is there any documented examples ?


Thanks a lot for your attention once more,

-Renan Souza