Hi Phil and Lynn,

I have been trying to solve my problem with your instuctions but I'm still not able to work it out I'm afraid. Maybe I am missing something...

Hi Paul,

It's true that I could simply drop my audit table and log all my auditing in my various dimension and fact tables but that would not be according

to my...

Hi Phil,

Yes that is exactly what I want to accomplish. Basically that I have Audit_ID with identity (1,1) that works as a PK in my Audit table and

my respective dimension...

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...