March 8, 2012 at 11:36 pm
- Using Script component as Transformation, Communicated with Web service for look up operation
- Script component will process row by row and hence we need to hit the service one time for each row that will impact performance
- Is there any properties(synchronous or asynchronous property, etc) that can be set to process all rows together, so that we can hit the web service only one time for looking up all records
How to store array values in SSIS?
March 9, 2012 at 4:54 am
You can try to store all the records in a recordset destination.
This stores the data into a variable of type object.
In a script task, you can use this variable to populate a dataset, which you can use to send the data to the webservice.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
March 9, 2012 at 7:48 am
Thanks Joen
I tried that too. Stored all rows of a single column in an Object variable.
How to assign this object variable to array variable inside the script
The Web service consumes parameters as array and returns a list containing 2 arrays and a boolen..
In return how to convert the returned list of arrays to columns inside the script ..
March 9, 2012 at 2:02 pm
This article explains how to read an object variable in a script task and how to put it in a dataset:
SSIS Design Pattern - Read a DataSet From Variable In a Script Task
The rest is up to you, I'm not a .NET programmer 🙂
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
March 12, 2012 at 12:50 am
Thanks Joen.
Let me try with scripting and get back to you with results 🙂
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply