Hi,
I am creating a SSIS 2005 package. This has a web service task. In web service task I have a web method that accepts two input parameters. I need to read values of these two parameters from an excel table. The table will have multiple values for each parameter. In a loop I need to invoke web method for each of these values in excel.
Please provide your suggestions on this.
Thanks,
Atul