daniel-johnsson (3/7/2013)
Thank you for your reply Paul.I'm using SQL Server 2012 (SP1), Developer Edition.
I use a OLE DB source to extract some data from 3 different tables from a specific database. I then
connect this component with the Audit transformation component. In the audit I selected the following information to audit:
Execution start time, Machine name, User name, Package name and Task name.
After that I create a data flow path between my audit transformation and an OLE DB destination where I load my Audit_table. When I created the audit_table
I created a column called Audit_id with identity (1,1).
This is as far as I get. Like I mentioned in my previous post I am unable to join the Audit_id in my audit_table with my audit_id columns in my various dimension tables.
I have 6 dimension tables and 2 fact tables which currently have audit_id column with the value NULL.
I hope this is all the information you need and if not please let me know.
// Daniel
I don't think I fully understand the structure of what you are doing.
Are you saying that AuditId in your dim tables should be a many to one FK to AuditId in your Audit table?
Is it just a case of retrieving the AuditId for a single insert to your Audit table and then passing that into subsequent data flows?
If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.