MSBI (SSIS/SSRS/SSAS) Online Training

Tuesday, February 10, 2009

How to retrieve files from folder and records from Table by using ForEachLoop Container:-

How to retrieve files from folder and records from Table by using ForEachLoop Container:-
Hi,
By using ForEachLoop Container we can repeat loop and send all files to execution.
1.For Each File Enemurator – Files from Folder
a.In the Collection tab first we can browse file folder and we can set the files along with extension like Screen 1.
b.we can set the variable in the Variablemapping tab,this variable will read the file names one by one from the loop like Screen2.
Screen1

Screen2

2.For Each ADO Enemurator – Records from Table
a.First we can select the columns from the table using ExcecutesqlTask,and we can assign these values to local variables and fullresultset to a system.Object Type variable like Screen 1,Screen 2 and Screen 3.
b.In the ForEachloopContainer Collection tab we can select that system.Object Type variable to ADOobjectSource_Variable like Screen 4.
c.We can set the local variable in the Variablemapping tab,this variable will read the columns one by one from the loop like Screen 5.
Screen 1

Screen 2

Screen 3
Screen 4
Screen 5

2 comments:

peterjohn said...

Pretty good post. I just came across your site and wanted to say that I’ve really enjoyed reading your posts. In any case I’ll be subscribing to your feed and I hope you will keep a good work!Cheer!

sap online training
software online training
sap sd online training
hadoop online training
sap-crm-online-training

peterjohn said...

This is one awesome blog article. Much thanks again.
I really enjoy the blog.Much thanks again. Really Great.


oracle online training
sap fico online training
dotnet online training
qa-qtp-software-testing-training-tutorial