SSIS Quick Question

Hi,

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?

Thanx

asked Mar 02 '10 at 05:30 PM in Default

technette
847 ● 45 ● 76 ● 88

(comments are locked)

1 answer:

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

sp_lock
8.1k ● 20 ● 26 ● 29

That's what we're looking to do. Have data entered by employees, verified by managers through a web app then inserted into the database. If you don't mind, what environment did you build the web app in? ASP.NEt?

Mar 02 '10 at 08:09 PM technette

Yes, ASP.NET. But it could be any app front end. The app is very simple with only basic changes allowed and a "accept" or "reject" option. If rejected the records are removed from the staging table.

Put enough checks in the app so that data integrity is still 100%

Mar 02 '10 at 08:40 PM sp_lock

(comments are locked)