shannonjk (12/8/2012)
Also one further quick question; since I do have 75+ tables I am loading on a nightly basis...would I just create multiple jobs to handle this load instead of multiple SSIS packages?
I'm assuming you have an overnight window where your data is not being updated.
I would imagine that you'd have a SSIS package for each DW dimension and Fact table; similar tables may be combined. Of those 75 tables, they probably logically break down to a smaller set of logically independent groupings. Say, customers, sales, inventory, ..., for example. You could create a seperate SQL Agent jobs that could run in those SSIS packages in parallel. Of course, they would have to be no dependencies. If the sales needs the customers to be updated first, then they would be in one package.
HTH,
Rob