Cannot Download WSDL file for Web Services task in SSIS


I still have this issue when I migrate SSIS packages from 2008 to 20014.
I have used the method mentioned from the below link and use the external WSDL file saved from an IE browser for Web Services Task as the source without overwrite.
Type your web service link to an IE browser:
https//thesite.com/myservice.asmx?WSDL
and save the xml file as your yourwebservicefilename.wsdl file.

http://social.msdn.microsoft.com/Forums/sqlserver/en-US/8e76f6e0-c61a-469c-bcc6-588c561b1565/wsdl-file-for-web-services-task?forum=sqlintegrationservices

Edit:
When deploy the package to use webservice, the webservice component needs to be refreshed to point to the updated wsdl file and find the correct method for the component.

Advertisements


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s