Skip to main content

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 from this blog

SSRS INTERVIEW QUESTIONS

Q: What is SSRS? Ø   SSRS or SQL Server Reporting Service is a server-based report generation software systems from Microsoft and is part of Microsoft BI. Ø   It is used for preparing and delivering interactive and variety of reports. Ø   It is administered through an web based interface. Ø   Reporting services utilizes a web service interface for supporting and developing of customized reporting applications. Ø   SSRS lets you create very rich reports (Tabular/Graphical/Interactive) from various datasources with rich data visualization (Charts, Maps, sparklines) Ø   SSRS allows are reports to be exported in various formats (Excel, PDF, word etc) Q: Explain SSRS Architecture? Reporting services architecture comprises of integrated components. It is a multi-tiered, included with application, server and data layers. This architecture is scalable and modular. A single installation can be used across multiple computers. It includes the fo...

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

TITLE: Microsoft Visual Studio ------------------------------ Failed to start project ------------------------------ ADDITIONAL INFORMATION: Exception deserializing the package "The process cannot access the file 'E:\SSASCube\HistoricalDataLoad\HistoricalDataLoad\bin\Development\HistoricalDataLoad.ispac' because it is being used by another process.". (Microsoft.DataTransformationServices.VsIntegration) ------------------------------ The process cannot access the file 'E:\SSASCube\HistoricalDataLoad\HistoricalDataLoad\bin\Development\HistoricalDataLoad.ispac' because it is being used by another process. (mscorlib) ------------------------------ BUTTONS: OK ------------------------------ While running SSIS package i got the error “The process cannot access the file ‘*.ispac’ because it is being used by another process”. I tried to close SSDT and run it again but, I still got the same error while compiling. Then, after searching over internet, I got...

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

Error: TITLE: Microsoft Visual Studio ------------------------------ Failed to execute the package or element.   Build errors were encountered. For more information, see the Output window. ------------------------------ BUTTONS: OK ------------------------------   Solution: We tried to close SSDT and run it again but, we still got the same error while running SSIS package. Then, we need to follow bellow solution: Step 1: Go to Task Manager–> Details Tab. Step 2: Locate the process “ DtsDebugHost.exe “. Kill this process. There might be multiple instances of this process. Kill all of them. Step 3: Rerun SSIS package