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.










Comments

Post a Comment

Hi User,
Thanks for visiting My Blog and please provide your valuable feedback and subscribe for more updates. Please don't post any spam content or comments.
Thank You

Popular Posts

Failed to execute the package or element. Build errors were encountered

Exception deserializing the package "The process cannot access the file because it is being used by another process."

Temporary enable and disable SSRS subscriptions