Goal Create an ETL audit table (tblETLAudit) Use an Execute SQL Task to enter entries into the ETL audit table Need to pass system and user variables to the Execute SQL Task Issues There are 4 system variables, and one user variable I want to p...

Hi folks , I just apologize to my reader for not posting from last week !! Rather than throwing lots of reason I will just say I am lazy . So here onwards I will try to be regular !! Continuing from my last post on...

Working on any SSAS project, might require a Time Dimension everytime. Recently, I had to create a Time Dimension with various datetime calculated columns in it. This calculations might help to create various user defined hierarchies in the dimension. ...

This property can be set as shown in below image: but I can't see any images?!...

This property can be set as shown in below image: but I can't see any images?!...