Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
james_wells
Yak Posting Veteran
55 Posts |
 Posted - 2012-10-23 : 06:13:44
|
| 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 with2012-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.50727the source project is targetting v2 .net and acccessed using visual C sharp express 2010file version generated is 1.1.36343.1607file version of the original is 1.1.36238.1540Can anyone help with what to try to debug this issue |
|
|
james_wells
Yak Posting Veteran
55 Posts |
Posted - 2012-10-31 : 12:15:06
|
| Sorted after much painThe 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.50727Not 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 |
 |
|
|
|
|
|
using DLL assemblies from SSIS Package