SSIS - Web Service Task, Certificates

[Paddy]

Hi All - new boy here and happy New Year to you...

I have a problem I could do with some pointers on. I have an SSIS package
to consume a Web Service provided by a 3rd party. This Web Service needs a
digital certificate installed to the Personal Store, I have installed this
fine and can confirm everything lives where it should.

I can create a HTTP Connection through SSIS fine and can select and use the
correct certificate and can test the connection successfully. Problem is
when trying to create the Web Service Task. I select the HTTP connection yet
when I test I get a "cannot create TLS/SSL" error which suggests it's not
using the certificate.

SSIS is using a "Network Service" account and I have used the WinHttpCertCfg
utility to give the service access to the certificate but still no joy. I
must have missed something stupid here.

SQL 2005 Standard Edition (sp1). .Net Framework 3.5 sp1

If you need any more information from myself - just ask. Any and all help
very much appreciated :)

[Paddy]

Didn't think it would help but I have upgraded to SQL 2005 sp3. I have also
run tests bypassing our Proxy server.

Unfortunately we're still getting this issue.

Thanks
Pat

[Paddy]

just for the sake of building up history for other people. Looks like the
'Test Connection' isn't a true test of connection as I needed to supply the
HTTP connection manager a set of proxy credentials to get past this.

Still getting an error though - Object reference not set to an instance of
an object..

Anyone any ideas on this one?

Thanks
Pat