July 18, 2011 at 2:52 pm
I have a 2005 SSIS package that I'm trying to execute a custom DLL through a script task. I've compied the dll to the "C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727" folder, I've registered it using the GACUTILS, I've added it to the reference in the script task, and I've added it uisng Imports in my VB code. I'm still getting the error "could not load file or assembly '<mydll>' or one of its dependencies. The system cannot find the file specified."
My dll is connecting to the CRM.dynamics.com database in the cloud and so I'm using other dll's to connect to the CRM database. The dll is written in Visual Studio 2010. I've compied the other dll's into the "C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727" folder, added them to the reference in the script task.
I'm running XP with the following installed:
SQL Server 2005
SQL Server 2008 R2
Visual Studio 2005 Developer
Visual Studio 2010 Professional
Any help?
Thank you,
Pat
July 18, 2011 at 3:44 pm
What version of SQL Server 32 or 64? Is the DLL compiled for a specific architecture or MSIL? Are all the related DLLs of the same configuration?
My first thought is that you are using a 64-bit SSIS version with 32-bit DLLs, which unfortunately happens all the time and causes problems.
CEWII
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply