MSBI Tutor

The history cleanup task deletes entries in the following history tables in the sql server msdb database. ·          Backupfile ·          Backupfilegroup ·          Backupmediafamily ·          Backupmediaset ·          Backupset ·          Restorefile ·          Restorefilegroup ·          Restorehistory By using the history cleanup task, a package can delete historical data related to backup and restore activities, sql server agent jobs, and database maintenance plans. Step 1: Drag and drop history cleanup task and edit it. Step 2: Give a new connection as History Cleanup Task Step 3: Select the historical data to dele...

The execute t-sql statement task runs transact-sql statements. This task is similar to the execute sql task. However, the execute t-sql statement task supports only the transact-sql version of the sql language and you cannot use this task to run statements on servers that use other dialects of the sql language.  Step 1: Drag and drop execute t-sql statement task and edit it. Give a connection as execute t-sql statement task.  Step 2: In T-Sql statement write a simple query as BEGIN SET NOCOUNT ON; TRUNCATE TABLE DimEmployee END Step 3: Click on View T-SQL Step 4: Execute a task

The execute sql server agent job task runs sql server agent jobs. Sql server agent is a  Microsoft  windows service that runs jobs that have been defined in an instance of sql server. You can create jobs that execute transact-sql statements and  active  scripts, perform analysis services and replication maintenance tasks, or run packages. You can also configure a job to monitor  Microsoft  sql server and fire alerts. Sql server agent jobs are typically used to automate tasks that you perform repeatedly. Step 1: Drag and drop execute sql server agent job task in control flow and edit it. Give a new connection as execute sql server agent job task . Step 2: In available execute sql server agent jobs select a job. Step 3: Click on view T-SQL Step 4: Execute a task

The check database integrity task checks the allocation and structural integrity of all the objects in the specified database. The task can check a single database or multiple databases, and you can choose whether to also check the database indexes.the check database integrity task encapsulates the dbcc checkdb statement.  Step 1: Drag and drop Check database integrity in control flow and edit it. Step 2: Give a new connection as Check database integrity task Step 3: In database column select database Step 4: Click on View T-SQL Step 5: Execute  a task

The back up database task performs different types of sql server database backups. By using the back up database task, a package can back up a single database or multiple databases. If the task backs up only a single database, you can choose the backup component: the database, or its files and filegroups. The following table lists the recovery models and backup types that the back up database task supports. Recovery model Database Database differential Transaction log File or file differential Simple Required Optional Not supported Not supported Full Required Optional Required Optional Bulk-logged Required Optional Required Optional Step 1: Drag and drop Back up database task in control flow and edit it. Step 2: Give a new connection as BackUp. Step 3: Select a database to give...

Sql server integration services includes a set of tasks that perform database maintenance functions. These tasks are commonly used in database maintenance plans, but the tasks can also be included in ssis packages.  Task Description Back up database task Performs different types of sql server database backups. Check database integrity task Checks the allocation and structural integrity of database objects and indexes. Execute sql server agent job task Runs sql server agent jobs. Execute t-sql statement task Runs transact-sql statements History cleanup task Deletes entries in the history tables in the sql server msdb database. Maintenance cleanup task Removes files related to maintenance plans, including reports created by maintenance plans and database backup files. Notify operator task Sends notification messag...

Creating a custom report template is no different than creating a new report; the only exception is the placement of the report template that you created in the appropriate location so that it appears as a template on the New Item/Report dialog box. Step 1: Go to all programs and select Visual Studio 2008 R2 Step 2: In files to create a new project (Ctrl + Shift + N) Step 3: Give report name as SSRS Step 4: Click ok and bellow window will appear Step 5: Go to solutions explorer and create a report as Template Step 6: Sample Template as shown in bellow Step 7: Click right button and Insert page header and footer Step 8: Go to tool box and drag & drop text box as Hindustan Aeronautics Limited Step 9: Click right button and insert image Import a image to your pc Step 10: Template as shown in bellow Step 11: Go to body properties and give a body borders Step 12: Go to footer and drag & dro...