Check Database Integrity 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