SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

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

james_wells
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
\\aggbssc2sql011\c$\WINDOWS\Microsoft.NET\Framework\v2.0.50727

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








james_wells
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  
 New 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.03 seconds. Powered By: Snitz Forums 2000