SSIS Exchange Web Services - Could not load file or assembly

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Data Warehousing » Integration Services » SSIS Exchange Web Services - Could not load...

SSIS Exchange Web Services - Could not load file or assembly

Rate Topic

Display Mode

Topic Options

Author

Message

MikeLPlates

Posted Saturday, October 27, 2012 7:43 AM

Grasshopper

Group: General Forum Members
Last Login: Wednesday, May 08, 2013 2:42 AM
Points: 13, Visits: 90

Hi I'm trying to write a Source component in a dataflow task to recover some details from Exchange.
Unfortunately when I ran it - I get

[GetEmail [1]] Error: System.IO.FileNotFoundException: Could not load file or assembly 'Microsoft.Exchange.WebServices, Version=14.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35' or one of its dependencies. The system cannot find the file specified.
File name: 'Microsoft.Exchange.WebServices, Version=14.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35'
at Microsoft.SqlServer.Dts.Pipeline.ScriptComponentHost.HandleUserException(Exception e)
at Microsoft.SqlServer.Dts.Pipeline.ScriptComponentHost.PrimeOutput(Int32 outputs, Int32[] outputIDs, PipelineBuffer[] buffers)
at Microsoft.SqlServer.Dts.Pipeline.ManagedComponentHost.HostPrimeOutput(IDTSManagedComponentWrapper100 wrapper, Int32 outputs, Int32[] outputIDs, IDTSBuffer100[] buffers, IntPtr ppBufferWirePacket)

WRN: Assembly binding logging is turned OFF.
To enable assembly bind failure logging, set the registry value [HKLM\Software\Microsoft\Fusion!EnableLog] (DWORD) to 1.
Note: There is some performance penalty associated with assembly bind failure logging.
To turn this feature off, remove the registry value [HKLM\Software\Microsoft\Fusion!EnableLog].

I've tried copyto local, moved the Exchange dll to same directory as the pack which is the only cluse from searching google etc.. and can't seem to find anything works

I would be grateful if anyone's got any ideas

It's Windows 7 - 64 Bit - and it doesn't make any difference when RunIn64 is set to true or false.

Post #1377948

Prakash-329355

Posted Wednesday, January 09, 2013 10:55 AM

Forum Newbie

Group: General Forum Members
Last Login: Wednesday, January 09, 2013 10:44 AM
Points: 1, Visits: 36

Hi Mike

I have same issue, did you find any solution at the end?

Thanks in advance

Post #1404901

MikeLPlates

Posted Saturday, January 12, 2013 1:02 AM

Grasshopper

Group: General Forum Members
Last Login: Wednesday, May 08, 2013 2:42 AM
Points: 13, Visits: 90

Hi Prakash

Unfortunately not, in the end I used EWS powershell scripting as part of a SSIS package. Not as elegant but it worked.

I've still got to sort out impersonation though - I got sidetracked with something more urgent.

Regards

Post #1406318

« Prev Topic | Next Topic »

Permissions