Yak Posting Veteran
Posted - 10/23/2012 : 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 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