c# - How to pass a List of custom objects in a SSIS Script Task? -
i have script task creates list of custom objects , sets them ssis object variable.
custom class:
public class dog { public string name { get; set; } }
code populate list , set ssis object variable "mydogs":
public void main() { list<dog> dogs = new list<dog>(); dog dog1 = new dog(); dog1.name = "fido"; dog dog2 = new dog(); dog1.name = "roofus"; dogs.add(dog1); dogs.add(dog2); dts.variables["mydogs"].value = dogs; }
in second script task, trying read "mydogs" object variable list:
custom class copied on in second script task:
public class dog { public string name { get; set; } }
main code in second script task:
public void main() { var vardogs = dts.variables["mydogs"].value; list<dog> dogs = new list<dog>(); dogs = (list<dog>)vardogs; }
my vardogs object correctly loads data ssis object variable "mydogs". however, when try cast vardogs list of type dog receive error message saying "unable cast object of type system.collections.generic.list".
does know how able cast var data list? thanks.
Comments
Post a Comment