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

SSIS data retrieval Expand / Collapse
Author
Message
Posted Tuesday, June 19, 2012 2:03 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, June 19, 2012 2:00 AM
Points: 1, Visits: 0
I want to retrieve data from another DB to my warehouse using SSIS.
Is it possible for the automatic retrieval and update my warehouse when data changes?
Post #1317764
Posted Tuesday, June 19, 2012 4:11 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Tuesday, August 5, 2014 2:55 AM
Points: 1,101, Visits: 5,280
It is possible with trigger right?

But, warehouse data need not be up-to-date with OLTP data right?
Post #1317859
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse