CLR Integration - Could Not Find Type '??' In Assembly '??'.

Hi,


I'm new to Integration services and .Net programming but am trying to
create a dll that I can access from Sql server 2005.


The dll read's an xml file and carries out some processing. I've run
the code as an console app and it works fine.


I have created the assembly in sqlserver thus:


create assembly PinCodeLoader from
'C:PinCodeLoaderPinCodeLoaderPinCodeLoaderinDebugPinCodeLoader.dll'
with permission_set = external_access


But when I try to reference the assembly from a stored proc


create procedure dbo.interface_processPinCodefile(@filename
nvarchar(1024))
as EXTERNAL name PinCodeLoader.PinCodeloader.Main


I get the following error:


Msg 6505, Level 16, State 1, Procedure interface_processPinCodefile,
Line 3
Could not find Type 'PinCodeloader' in assembly 'PinCodeLoader'.


I understand the context of the syntax should be
assembly_name.class_name.method_name. The first lines of the code in
the DLL are as follows


namespace PinCodeLoader
{
class PinCodeLoader
{
static void Main(string[] args)
{


Therefore assembly = PinCodeLoader, class_name = PinCodeLoader and
method_name = Main. Which should equal
EXTERNAL name PinCodeLoader.PinCodeloader.Main, I thought.


Has anybody come across this or can they offer any assistance?


Many thanks,


Paul