SSIS Quick Question


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?


more ▼

asked Mar 02, 2010 at 05:30 PM in Default

avatar image

1.4k 100 114 121

(comments are locked)
10|1200 characters needed characters left

1 answer: sort voted first

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!

more ▼

answered Mar 02, 2010 at 05:43 PM

avatar image

10.9k 27 37 37

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.



asked: Mar 02, 2010 at 05:30 PM

Seen: 1153 times

Last Updated: Mar 02, 2010 at 06:42 PM

Copyright 2018 Redgate Software. Privacy Policy