custom DLL

I have a custom DLL in C# which does a lot of calculations.

I need to use it in my DataFlowTask. I wanted to add it as a reference in ScriptComponent and use it from there, but I do not see my dll there.

The dll is sign but does not have Post-build event command filled in the properties of the project and my dll is deployed and installed to assembly.

What do I do wrong?

How can I use my dll in ScripComponent? Any other options? What am I missing?

Thanks.

Vita wrote:

How can I use my dll in ScripComponent?

Take a read of this:

VSA requires DLLs to be in the Microsoft.Net folder (but not all the time)

(http://blogs.conchango.com/jamiethomson/archive/2005/11/02/SSIS_3A00_-VSA-requires-DLLs-to-be-in-the-Microsoft.Net-folder-_2800_but-not-all-the-time_2900_.aspx)

-Jamie

|||

Got it!

C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727

Would I be able to debug it?

|||

Vita wrote:

Got it!

C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727

Would I be able to debug it?

Unfortunately you can't step through the code in the script component. The best you can do is use message boxes to provide debugging info.

Stepping through code in the script task should work just fine.

-Jamie

|||

Interesting!

I have not used script task yet.

What can it be used for?

Can I calculate some formulas from the data I have in the Database using my custom dll as reference and update (not insert) a table which has some empty fields. How would I specify for example that one field from one table must be added to another field in another table and update third table based on the id?

Thanks a lot.

|||

Vita wrote:

Interesting!

I have not used script task yet.

What can it be used for?

Can I calculate some formulas from the data I have in the Database using my custom dll as reference and update (not insert) a table which has some empty fields. How would I specify for example that one field from one table must be added to another field in another table and update third table based on the id?

Thanks a lot.

Script Component works in the dataflow which means you execute .Net code on data in your pipeline.

Script Task is a task in the control-flow. You can basically do what you want with it - think of the script task as just another host for the clr.

Does that help?

-Jamie

|||thanks a lot!