April 16, 2009 at 1:04 pm
I will google this topic further, but, if anyone has good articles or work around to this then please let me know.
This is what I'd like to achieve:
1. Pass a list of parameter to a ssis package
2. Be able to refer to that parameter or list of parameters within the package
I stumbled on this in the past, but, did not have enough time to research.
April 16, 2009 at 1:22 pm
U want to create a package similar to a method (in c#) and passing collections to it. There is an object data type in SSIS that can be used to enumerate\loop by ordinal positions of items in it. I have used it to retrieve a list of values in an object type and use it in a For Each loop container, but not as anything else. I could also use a combination of configurations + variable (expressions) to achieve this.
Hope this was helpful.
April 16, 2009 at 1:24 pm
Configurations: Specifically the Parent Package Variable. I have created a metadata driven ETL to pass a configuration param of table schema name to packages.
April 16, 2009 at 2:06 pm
Thanks for the idea. I'll try it out.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply