Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SQL server integration Services(SSIS) Expand / Collapse
Author
Message
Posted Wednesday, November 14, 2007 1:34 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, November 15, 2007 10:09 PM
Points: 2, Visits: 7
Can anyone help regarding the SQL server integration Services(SSIS), ETL
We have requirement like this:
We have Live Database( LIVE_DB ) and Reports Database (REP_DB)
I want to trasfer the few tables data from LIVE_DB into the REP_DB for end of the day using SSIS
If any new records are added, updated or deleted in LIVE_DB, these should reflect in the REP_DB, Our requirement is not to delete the old data, we should append or delete or insert the new transaction data in REP_DB.

Thanks in advance, if anyone help me in resolving this issue.

Regards,
Bhushanam.



Post #421958
Posted Wednesday, November 14, 2007 5:46 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Tuesday, August 10, 2010 5:07 AM
Points: 2,732, Visits: 23,078
Assuming you have a primary key (or some unique key that cannot be changed on a record) you can do this very easily.

Look at the SCD wizard.

Yes, it is true that you are not updating a dimension, but the wizard will walk you through exactly what you are proposing.
Post #422049
Posted Tuesday, November 20, 2007 10:41 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, April 21, 2011 12:12 AM
Points: 1, Visits: 64
Michael Earl (11/14/2007)
Assuming you have a primary key (or some unique key that cannot be changed on a record) you can do this very easily.

Look at the SCD wizard.

Yes, it is true that you are not updating a dimension, but the wizard will walk you through exactly what you are proposing.


Hi i got 60 sql servers i would like to find version of sql server and service
from one server to all servers how can i do that ?
Post #424238
Posted Friday, October 12, 2012 3:44 PM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Tuesday, January 28, 2014 11:34 AM
Points: 313, Visits: 177
You must first define the way you will capture the changes in the LIVE_DB.
What is the retention policy of this,
you can partition your data by datetime and have a full load to the rep_db
or can have logical deletion in REP_DB
Again, the question is what means you will use to detect the changes?
If you want to go with logical deletion use SCD techniques , also you need the changes capyture abiity.
It can be done through audit, triggers , row version etc..

Post #1372376
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse