Everytime we create a cube for analysis services Date and Time Dimensions are needed to slice and dice the historical Data. Sql Server Analysis Services uses the Time Intelligence Features to populate the date and time. Its posted in detail in this blog. However we need to use them in our relational Databases to do [...]
Jan
20
2010
20
2010
Jan
20
2010
20
2010
Running SQL Reporting Services Report from SSIS
Whenever you create a new Subscription in Sql server reporting services, a new job is created under the Sql agent as shown in the figure below. You can use the msdb.dbo.sp_start_job procedure to start the job. In SSIS create a new SQL task and run the job wherever required exec msdb.dbo.sp_start_job @job_name = ‘JobName’ For [...]
