dbTalk Databases Forums  

Adding assembly in SSIS script task

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts


Discuss Adding assembly in SSIS script task in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Gayatri
 
Posts: n/a

Default Adding assembly in SSIS script task - 05-02-2006 , 04:40 AM






Hi all,

I want to add assembly in a script task of SSIS. The procedure, I
followed is:

1. copy the .dll in 'C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727'
folder (that reference window does not have option for brows and it
wants the dll to be in the above folder else it doesnt get enlisted in
the available list of dlls.
2. Add reference of that DLL.
3. Call some function (I have created test DLL which even doesnt even
return anything or doesn access any I/O) The code is

using System;
using System.Collections.Generic;
using System.Text;

namespace TestLibrary
{
public class Class1
{
public void retString()
{
int c = 12;
}
}
}

4. Create the instance of this class in the script task and call the
function.

Somehow, it throws the following error:

'Could not load file or assembly 'TestLibrary, Version=1.0.0.0,
Culture=neutral, PublicKeyToken=null' or one of its dependencies. The
system cannot find the file specified.'

Could somebody please help me out in this problem??

Regards,
Gayatri.


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.