This project is read-only.

Please consider this Post-build event

path "C:\Program Files\Microsoft SDKs\Windows\v6.0A\bin"
gacutil /uf "SSISWCFTask100"
del "C:\Program Files (x86)\Microsoft SQL Server\100\DTS\Tasks\SSISWCFTask100.dll"
copy "$(TargetDir)SSISWCFTask100.dll" "C:\Program Files (x86)\Microsoft SQL Server\100\DTS\Tasks\"
gacutil -i "$(TargetDir)SSISWCFTask100.dll"

First of all, you have to add the component to the ToolBox in the category “Control Flow Items” in the usual way… right click, you choose the “SSIS Control Flow Items”, you search and check “Dynamic WCF Task” and then click the OK button.

 image

Did you see the Icon and the component name of the component in the ToolBox?

image

Add some variables that will be used in this example:

image

So… we defined the Service URL into WCFServer variable.

Double-click on the component and you will see the component’s interface (a simple one) :

image

So, we choose the right variable that we already defined (You can enter a text like “http://localhost:8080/WcfSamples/DynamicProxy”, if you want)

In the Service Contracts ComboBox you will find your exposed [ServiceContract]:

image

You choose the ServiceContract and the Methods (Operation Contracts) ComboBox will be filled with the correspondent values:

image

For example, we will choose ‘Add’ method:

image

… and the Parameters Grid will be filled with the corresponded parameters of the selected method. Because we will execute a method that returns a value, into the ‘Output Value’ Combobox you will be able to specify the variable that will recuperates the method returned value.

Clicking onto the button corresponding to the ‘f(x)’ column, it will show you the Expression Builder as following:

image

and for the second parameter we will choose a variable (not an expression, but you can if you want –> that’s just an example):

image

…and for the OutputValue we choose the ‘Result’ parameter.

Let’s test it!

We add a “Script Task” with the following source code:

MessageBox.Show(Dts.Variables["Result"].Value.ToString());

We link the two components:

image

…and we execute the SSIS Task, and we obtain this:

image

The content of the log panel:

image

That’s All! Good luck!

Last edited Aug 31, 2011 at 8:24 AM by cosminfr, version 12

Comments

No comments yet.