For Loop Container
STEP 1: From the control flow items drag
& drop the for loop container.
STEP 2: Giving variables to the Package first.
Process give right click & select variable option in that.
Then we get 1 dialog box
In the left side below variables click
on add variable button we get Name, Scope, Data Type & Value.
Give Name Scope Data type Value
intval default
Package INT32 0
finval default
package INT32 3
STEP 3: Now edit for loop. By giving
right click on for loop we get edit option then click on it.
By clicking on edit option we can get for loop
editor
In the dialog box we had for loop
properties in that we have to give initexpression as @intval=0, Evalexpression as@intval<=@finval,
Assign expression as @intval=@intval+1. Then click on ok
After click on ok button we get one
dialog box
Now go back to control flow main page by
clicking toolbox which is besides the variables button.
STEP 4: Writing script: Drag & drop
the script task which is in the control flow items into for loop container.
Now right click on script task & we
get edit option click on it.
Then we get script task editor
In that page click edit script… button
then we get integration services script task page.
In this page we have to write the script
as MessageBox.Show("challabalu"); Then save the
file.
Now go back to main page here we had
start debugging button( It is a green button).
Click the button. By clicking that
button we get the result as what we had return in the script.
After completion of this task we can save the
file & click stop debugging button (It is in blue color).
After clicking it we will come back to
main page.
Balu vary nice articles, its very useful
ReplyDelete