x

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

more ▼

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

avatar image

technette
1.4k 100 113 120

(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

sp_lock
10.5k 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

By RSS:

Answers

Answers and Comments

SQL Server Central

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

Topics:

x1146
x41

asked: Mar 02, 2010 at 05:30 PM

Seen: 1146 times

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

Copyright 2016 Redgate Software. Privacy Policy