Hi,
I am new in SSIS development. In the script task of the Control Flow, how to use my custom classes (that use SMO and DTS for building a package and are written in C##?). If not the Script Task then which tool I have to use?
Natali Rozin wrote:
Hi,
I am new in SSIS development. In the script task of the Control Flow, how to use my custom classes (that use SMO and DTS for building a package and are written in C##?). If not the Script Task then which tool I have to use?
If you have compiled them into assemblies then you can reference them.
You should read this though:
VSA requires DLLs to be in the Microsoft.Net folder (but not all the time)
(http://blogs.conchango.com/jamiethomson/archive/2005/11/02/2341.aspx)
-Jamie
thank you very much Jamie.
Did you put your DDLs into the root of the Microsoft.Net folder? Through "Add Reference", I cannot find my DDLs I just put into C:\WINDOWS\Microsoft.NET\Framework
thank you very much Jamie.
Did you put your DDLs into the root of the Microsoft.Net folder? Through "Add Reference", I cannot find my DDLs I just put into C:\WINDOWS\Microsoft.NET\Framework
Natali,
You should put it into the appropriate .Net Framework version folder (I always just pick the highest). e.g.:
C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727
My apologies, the post I linked to above does not explain this does it?
-Jamie
Thank you - all are working!
The problem was I put mine into C:\WINDOWS\Microsoft.NET\Framework\v3.0 and do not have VS SDK yet.
In C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727 works well!
thanks again
