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 Event Log ETL Data Mart Expand / Collapse
Author
Message
Posted Tuesday, July 8, 2008 9:16 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Monday, October 25, 2010 10:10 AM
Points: 297, Visits: 267
Has anyone out there tried to create a data mart based on the SSIS Event Log data? I have a need now to increase the visibility into the ETL processes I manage at my company and am leaning towards a mart rather than just OLTP queries for the reports. The main reason I'm leaning towards the mart is that there are different data sources from which the report data is collected that needs to be consolidated.

Anyone?



Cheers,

Ben Sullins
bensullins.com
Beer is my primary key...
Post #530457
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse