I want to pull data that is entered on a form, create a staging area for approval, then load into the database.
Will SSIS facilitate the staging area?
Any Ideas on how I can implement this with SSIS?
Who needs to approve the staged data?
I have done something similar by inserting the data into a "staging" table . Once the data has been approved/passed (via a web app) then SSIS/SP inserts/updates the live data
I know this is basic but works for me!
answered Mar 02 '10 at 05:43 PM