Database II Undram Sambuu HomeBrewR Overview Steps to create - - PowerPoint PPT Presentation

Database II

Undram Sambuu HomeBrewR

Overview

• Steps to create SSIS Package
• STORED PROCEDURES
• Steps to create JOB

S S IS

• SQL Server Integration Services (SSIS) is a

component of the Microsoft SQL Server database software that can be used to perform a broad range of data migrationtasks.

S TORED PROCEDURES

• Stored Procedures are a batch of SQL statements

that can be executed as a job.

• Benefits: centralize data access logic, security
• Syntax:
• CREATE PROCEDURE (NAME OF THE PROCEDURE) SP_SU_HOMEBREWR AS

SELECT *, CAST( GETDATE()AS DATE) DATESTAMP FROM ABDDWSAND.dbo.SU_HOMEBREWR

JOB

• A job is a specified series of actions that SQL

Server Agent performs. Use jobs to define an administrative task that can be run one or more times and monitored for success or failure.

• Benefits: can be scheduled, sends notification