Hi Everyone, Time dimension is the most popular and common in data warehouse systems. We always create scripts to generate time intelligence in our data warehouse and analysis services. The SSIS package has two parameters (Variables) , "StartDate" , "EndDate". There is a SQL script in the project to create the destination table (in TempDB). Script component is the source of data flow and its generating a standard time dimension. It also prepares "TimeKey" with the most...