Skip to Content
0
Former Member
Dec 02, 2011 at 05:37 PM

Passing Dimension Members to Logic Task in SSIS

30 Views

I have a package that pulls data from a source and loads it into BPC. As a part of the package, if data is loaded into prior periods (I identify this through a query and put the prior periods and accounts into variables), we then need to run a piece of script logic that rolls forward the necessary balances based on the time periods and the accounts included. Right now, the package generates an email and includes an expression noting the prior time periods and accounts, and and then the users go and manually run the logic for the time periods and accounts specified in that notification email. However, we want to automate that step at the end of the package. What is the best way to pass the time period and account variables into script logic to limit the scope to just those accounts and the time periods specified?