Analysis Cubes Wizard generates 40 SSIS packages.
Which packages should I run first ?
Is there any order of executing these packages or can I randomly execute these packages ?
*This post is locked for comments
I know it should be scheduled.
But, now I am testing to load the data into Datawarehouse table, so I run each package manually.
A few days ago, I read the article and it says that among 40 SSIS packages, these 3 packages, 'DynamicsGP_<source_db>_to_<warehouse_db>_PackageMaster', 'DynamicsGP_<source_db>_to_<warehouse_db>_Run_GL_Budgets_Master',
'DynamicsGP_<source_db>_to_<warehouse_db>_Run_AA_Budgets_Master'
should be run first.
So, I want to know if there is any order when I execute the 40 SSIS packages.
SQL Guy, The installation process should setup a job to routinely schedule the running of the SSIS packages, which I supposed could be run manually if needs be, but need to be scheduled to refresh the data periodically.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,269
Super User 2024 Season 2
#2
Martin Dráb
230,198
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (