How do I add a .DLL to my SSIS script task?

Hot Topic

where is the "render" method in 2005? Immediate help needed..!
accessing components and task from scripting task
HOW to pull merge subscriptions in SQL server 2000 using stored procedures ??? (URGENT)
Insufficient system resources exist to complete the requested service
error : 18452 in clustering; very urgent
Mailing Labels - Reporting Services 2005 - Multi-Column format
"Prediction steps" has no effect for "Microsoft Time Series" algorithm
SSIS datatypes issue.
sql server 2005 on itanium 2 and SAN storage
Database Mirroring is not working at all in RTM

SQL Server

Client unable to establish connection Encryption not supported on SQL Server. (Microsoft SQL Native Client)
Get last record in a SQL database
Import/Export data with SQL Server 2005 Express
Where is the AWDataWarehouseRefresh sample? Missing from SQL 2005 April CTP
DataBase Connection
SSIS - XML config file
SQL Server 2005
Reports vs. ReportServer permissions
Reporting Services June CTP
Pocket pc 2002 sqlce data synchronization with sql server 2000 (SP4)

How do I add a .DLL to my SSIS script task?

Hi,

I have some code written in .NET sitting in a .DLL. I would like to call this code from a script task block of code... but how do I add the .DLL to my project If I go to References->Add References, there is no "Browse" button like there is in "normal" VS.NET. How can I add this .DLL So far I have had to copy and paste the code from the .DLL into my project, but this is ugly!!

Thanks for any help.

Answer this question

How do I add a .DLL to my SSIS script task?

  • smattessich

  • Jayasankar-eSystems

    Thanks for your reply. However, I am now having problems trying to just add a .DLL to the GAC! I am following thse steps

    1) goto .NET command line and type "sn -k SomeStrongName.snk" (it tells me the key was created)

    2) add the this to the top of my code after imports, "<Assembly: AssemblyKeyFile("SomeStrongName.snk")> "

    When I try to compile the .dll, it gives this error: "Error creating assembly manifest: Error reading key file 'SomeStrongName.snk' -- The system cannot find the file specified. "

    Do you have any clue why this is happening Is there somehwere i should move this .snk file to Or do I have to change a path setting or something

    Any help is greatly appreciated!!!

  • NelsonCE

    I'd say the path is incorrect to the key. From memory something like ..\..\Keyfilename.snk worked best in VS 2003, but in VS 2005 just set the key in the Project Properties, Signing page, it saves all the hassle of specifying the AssembkykeyFile attribute by hand, it does it for you under the covers.

  • How do I add a .DLL to my SSIS script task?
Answer this question