22 Foreach Loop Container in SSIS Example

Foreach Loop Container in SSIS Example | Foreach loop container in SSIS | Foreach loop in SSIS
Download the file\script used in the Video from below link

"insert into FileInfo values ('"+ @[User::FilePath] +"',"+ (DT_WSTR,12) @[User::Cnt] +",GETDATE()) "

Foreach Loop Container in SSIS Example
What is the use of foreach loop container in SSIS?
How do I create a foreach loop container in SSIS?
What is the difference between for loop container and foreach loop container in SSIS?
How many loop containers are in SSIS?

[xoxoxoxo]

Hi buddy, thank you for sharing your experience. Even though i had difficulties to understand sometimes, i got the idea and managed to practise it by myself at the end of the day.

[sowmyareddy]

It's really nice explaining for beginners...Thank You

[MVinodKumar-tttu]

Hello Sir,

We created variable Filepath and mapped it with foreach Loop and in Flat File Source we took initial file and in Flat file connection manager properties expression just mentioned Filepath variable. How it worked here sir? like how it looped through all files?Please clarify sir. confused

[kiranraju]

Hi,
Really nice video. Thanks for the video.

[abdulsami]

Dear Aqil, this is really useful, by any chance can we download the video as well please?

[sriniwaaskorampalli]

Hi Sir,
Canu please Provide Code for Insert statement in Logs through Expression... I am getting error

[data]

This one is difficult I got through everything and then my Foreach Loop and 'Logs' SQL Script got an error that I couldnt figure out:

Error: 0xC002F210 at Logs, Execute SQL Task: Executing the query "insert into FileInfo values ('C:\Users..." failed with the following error: "Column name or number of supplied values does not match table definition.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.
Task failed: Logs

Any help would be appreciated. Moving on forward from here.

[amanahmed]

8:46
There is no Folder tab in for each loop container in 2019

[rahulgautam]

Hello Aqil,
As we know, we have three options in the retrieve file names. Could you please tell me how to know where we should the specific option. Generally, I used the fully qualified option. But bit confuse about rest options.
1. Name and extension.
2. Fully qualified.
3. Name only.
Thanks.

[BTECH]

If i executed more than 1 time rows were doubling. Could you tell me how to use delete statement in execute sql statement for this for each loop

[sagittariusguy]

y did u bring the ROWCOUNT in picture, is it really necessary just to confuse people .

[aerobatM]

You should take a little more time to explain what you're doing on each step. I had to stop and rewind the video MANY times to figure out what you did. Also, it was extremely difficult to figure out what you typed in the SQL Statement Source in the Logs task.

[sangeethak]

How to use sort inside forech container?

[MD-lulb]

Hello there,
How to generate a single flat file from multiple values from for each loop like I have 5 groups but in my out put sometimes I need single destination and sometimes multiple output . Like 5 flat files destination and sometimes one destination it depends on the requirements. Please help !

[ankbala]

At 4:34, header column names having double quotes.. how to get rid of them?

[verysecret]

great video, but please stop saying 'You know" I have counted 'You know" 182 times. Its just too often.

[AshishPatel-ylbk]

How to loop load latest file present in 10 different folder in root directory ?

[sriniwaaskorampalli]

hi sir, why i am getting all data in double quotes in SQL table

[tejaswinerella]

Hii Aquil, I'm facing this issue Can you please help me with this


Error: 0xC002F210 at Execute SQL Task, Execute SQL Task: Executing the query "insert into FileInfo values ('C:\Files\CSV Files\C..." failed with the following error: "Incorrect syntax near '.3520'.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.
Task failed: Execute SQL Task
Warning: 0x80019002 at Foreach Loop Container: SSIS Warning Code The Execution method succeeded, but the number of errors raised (1) reached the maximum allowed (1); resulting in failure. This occurs when the number of errors reaches the number specified in MaximumErrorCount. Change the MaximumErrorCount or fix the errors.

Any help would be appreciated

[lakshmiboddu]

I want to display same date value into a table whatever the date available in filename .