CODEWITHSUNDEEP
c#ssis
Nexuz
Nexuz

Reputation: 192

SSIS Package Parameter to Script Task List<KeyValuePair>

I'm working on a SSIS package which contains a script task. In this task I have a list of key value pairs which are hard coded string objects. What I would like to do is have a project parameter which is a list of strings which can then be passed to the script task through means of a read only variable and then parsed into a list of KeyValuePairs. Is this possible as I am unable to find material relating specifically to what I want.

Upvotes: 0

Views: 566

Answers (1)

Tab Alleman
Tab Alleman

Reputation: 31785

There is no "list" or "array" type variable in SSIS. You can do one of two things:

  1. Make a delimited string variable and split it in your script task.

  2. Make an object type variable, which is basically a datatable or resultset, and iterate through it in your script task.

Upvotes: 2

Related Questions