STAGE SQL AGENT Dimensions

agent86ray / SQL-AGENT-JOB-DATA-MART

This project builds a data mart from the SQL Server Agent tables. It implements an increment load design and includes type 2 slowly changing dimension handling for jobs and job steps.

1 stars 0 forks source link

STAGE SQL AGENT Dimensions #11

Closed agent86ray closed 3 years ago

agent86ray commented 3 years ago

SSIS Package: STAGE-SQL-AGENT-Dimensions

GET ETL LOG EXTRACT and STAGE sysjobs EXTRACT and STAGE sysjobsteps