Yak Posting Veteran
Posted - 04/19/2013 : 02:36:12
| Hi All,
i have a stored procedure it will generate an result set with dynamic number of columns.
we have dynamic sql's in SP the number of columns in result set will depend on some conditions inside SP.
with few input values SP result set will return 10 columns
with few other input values result set will return 30 columns
Pls suggest the way how can i map these columns in SSIS dynamically.