Please start any new threads on our new site at We've got lots of great SQL Server experts to answer whatever question you can come up with.

Our new SQL Server Forums are live! Come on over! We've restricted the ability to create new threads on these forums.

SQL Server Forums
Profile | Active Topics | Members | Search | Forum FAQ
Save Password
Forgot your Password?

 All Forums
 SQL Server 2005 Forums
 .NET Inside SQL Server (2005)
 using DLL assemblies from SSIS Package
 Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Yak Posting Veteran

55 Posts

Posted - 10/23/2012 :  06:13:44  Show Profile  Reply with Quote
i have had no involement in assemblies / DTS in SQL 2005 so hopefu;;y the info below will make sense

i needed to change c sharp code a departed colleague left us. In theory we have the correct project and when the compiled DLL are generated and copied into the relevant windows folder the chnage was not reflected.

so i created a copy of the DTS package which worked fine when the reference is added to the original DLL however when the reference is deleted and the reference is added to the new DLL even if its compiled withoit the intended change it failz with

2012-10-23 10:30:11.77 Code: 0x00000002 Source: Process Invoices Description: The script threw an exception: Could not load file or assembly 'AB.Agri.Data.Dynamics, Version=1.1.36343.1607, Culture=neutral, PublicKeyToken=null' or one of its dependencies. The system cannot find the file specified. End Error DTExec: The package execution returned DTSER_FAILURE (1). Started: 10:30:11 Finished: 10:30:11 Elapsed: 0.203 seconds. The package execution failed. The step failed.

the DLL reside in

the source project is targetting v2 .net and acccessed using visual C sharp express 2010

file version generated is 1.1.36343.1607
file version of the original is 1.1.36238.1540

Can anyone help with what to try to debug this issue

Yak Posting Veteran

55 Posts

Posted - 10/31/2012 :  12:15:06  Show Profile  Reply with Quote
Sorted after much pain

The DLL that i have compiled needed to be signed with a stong file key and stored in the CAC (Global Assembly Cash) which has a virtual directory of C:\Windows\assemblies.

When viewed through exployer it appears a single folder.

Drag and drop the target assembly from the source folder in my case \\aggbssc2sql011\c$\WINDOWS\Microsoft.NET\Framework\v2.0.50727 to the windows assemblie folder and it will resgister and install the assembly.

Then within the DTS project the assmbly references were remoed and added for the recomplied assemblies that existed in \aggbssc2sql011\c$\WINDOWS\Microsoft.NET\Framework\v2.0.50727

Not convincee that assemblies and SSIS are a good mix but as i have inherrited this solution and also new to me i am just pleased to get it working

Go to Top of Page
  Previous Topic Topic Next Topic  
 Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.02 seconds. Powered By: Snitz Forums 2000