WSDL link in SSIS

Question

WSDL link in SSIS

keywestfl9

SSCertifiable

Points: 5215
More actions
August 13, 2010 at 10:34 am

#226030

For each environment the wsdl link differs, i want to be doing it outside the package by changing the link based on the migration of the package to different environment.
How can i do it and will i be able to achieve inside script task or web service task? Please suggest

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Baskar B.V SSCrazy Points: 2823 More actions · Answer 1

keywestfl9 (8/13/2010)
For each environment the wsdl link differs, i want to be doing it outside the package by changing the link based on the migration of the package to different environment.
How can i do it and will i be able to achieve inside script task or web service task? Please suggest

You can do this using SSIS configuration and can define the configuration to be either based on environment varible, separate xmlconfig or using sql table. You need to map that under menu SSIS - Configurations.

[font="Arial"]BASKAR BV
http://geekswithblogs.net/baskibv/Default.aspx
In life, as in football, you won’t go far unless you know where the goalposts are.[/font]

keywestfl9 SSCertifiable Points: 5215 More actions · Answer 2

Thank You.

I have used the config file for different servers but how do i control the wsdl link thru that and what task i use

For example

DEV

http://test-sit.com/test.asmx?wsdl

UAT

http://test-UAT.com/test.asmx?wsdl

Baskar B.V SSCrazy Points: 2823 More actions · Answer 3

keywestfl9 (8/13/2010)

Thank You.

I have used the config file for different servers but how do i control the wsdl link thru that and what task i use

For example

DEV

http://test-sit.com/test.asmx?wsdl

UAT

http://test-UAT.com/test.asmx?wsdl%5B/quote%5D

Suppose if you are using webservice task and want to configure WSDL property, in your SSIS configuration you need to expand Executables - > Web Service Task -> Properties -> WSDLFile. Once you define this property you can keep separate xmlconfig file for each environment and add your value accordingly into that file. In the SQLAgent, you need to pass the appropriate config file. Hope this answer your question.

[font="Arial"]BASKAR BV
http://geekswithblogs.net/baskibv/Default.aspx
In life, as in football, you won’t go far unless you know where the goalposts are.[/font]

keywestfl9 SSCertifiable Points: 5215 More actions · Answer 4

Thank you again

if i have to do using script task how do i achieve it?