Execute SQL Task

April 27th, 2010 by aabhaanjan

SSIS Tasks :-

Execute SQL Task:

  1. 1. Execute SQL Task: – Execute sql task execute a stored procedure or sql query.

Process to create a package:-

a)      Open Business intelligence Development studio (BIDS) à select Fileà New Project àchoose Integration service Project

BIDS

a)      Put the project name and press ok button .The Project will be created and screen will be look like this and you will find default package.dtsx package file in solution explorer.Rename the package name whatever you would like to change .

Execute_SQL_task

a)      Drag and drop Execute Sql Task control to perform some operation into database and double click on Execute SQL Task  .The following screen will be appear :-

Execute_SQL_task.1

d)Select Connection Type , Click connection to establish connection with database.

Execute_SQL_task.4

e)      Enter the sql Query or procedure in SQLStatement Properties and click OK button.

Execute_SQL_task.5

e)      You have done all process ,Now your package is ready to execute . Press F5 to run the package .When you will press the F5 , the Package will be execute and data will be inserted into database and screen will be look like this .

Execute_SQL_task.6

Tags: , ,