reza_rad at Experts Exchange Reza Raad at Microsoft Tech Net SSIS blogs: SSIS Team Blog Todd Mc Dermid's Blog Pedro's Blog SSIS Junkie (Jamie Thomson) Rafael Salas SSIS Talk (Phil Brammer) SSISBI (Duane Douglas) Shahriar Nikkhah's Blog BI Solutions ( Amin's BI blog )For example you want to select special sub directories based on specified conditions and then you want to loop through them. so it's better to create a variable which contains array of these values and then just loop in the items of this variable. but there is a difference; you can load data into ADO with Record Set destination or with data sets in . this will be very helpful when you work on large data streams every night in your ETL scenario, in those cases some tuning tips like this will be helpful. NET code without using data sets and this will save memory consumption, because arrays use much lower resource and memory than dataset.
Regards, Reza Thanks for getting me started with your example!All SQLPSX development has moved to Github Project Description The primary goal of SQL Server Power Shell Extensions (SQLPSX) is to provide intuitive functions around the SMO objects which are backward compatible with SQL 2000.A secondary goal is to provide an application which reports flatten/effective security settings.You create, modify, and delete package parameters by using the Parameters tab in the SSIS Designer.
You associate a new or an existing parameter with a task property by using the Parameterize dialog box.The development of the test framework is going to focus on the platform capabilities of the tool.