sql server 2008 - How to fix the error 'input Web Services Description Language (WSDL) file is not valid'? -


i'm facing problem when deploy dtsx file production server.

in dtsx file consume webservice through web service task, webservice asks wsdl file has download local path.

there no problem in machine, in production server won't ever exists.

i think not acceptable ask client me permissions enter in production server , create folder store wsdl file. in addition happen when wsdl changes? have deploy dtsx package again , replace wsdl file in server. think not option.

so, question is,

is there possible way avoid have physical file wsdl especifcation, or deployed within dtsx deployment package, or save in variable, or how else that?

i've been searching lot, still not luck.

any appreciated.

to achieve this, 1 option make use of script task , of .net namespace system.net.webclient, can access wsdl url path , download contents of wsdl file system's temporary folder path. can system's temporary folder path, value of environment variable temp, using .net method system.io.path.gettemppath(). newly generated temporary path of wsdl file can stored in ssis package variable, can configured in web service task use instead of relying on local path. initially, during development need have wsdl file in local path once deploy package production, wsdl file need not exist on local drive.

hope helps.


Comments

Popular posts from this blog

linux - Using a Cron Job to check if my mod_wsgi / apache server is running and restart -

actionscript 3 - TweenLite does not work with object -

jQuery Ajax Render Fragments OR Whole Page -