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