SSIS 2008 Series: The For-Each Enumerator

[pjw611]

Very useful for someone getting started with using the foreach container - even down to the way that you imported the header rows from each of your sample files - something that most folks wouldn't want to do. It leads to questions on how to prevent that from happening, which is another video!

[achinmaheshwari]

Thanks a lot Rajesh. Good video to clear the usage of variables in Foreach and Connection manager. Also please do look into the data which has been inserted into Table. the data is dirty as it inserts column names department Id as data which could have been names of columns

[creativecommIT]

@achinmaheshwari Thanks for feedback

[anuragydv]

Thanks a lot Rajesh

[mynameheman]

Thanks Rakesh for posting this , Please post more with various data / control task if you can .

[praveenadigopula]

Hi, I was trying the same scenario and I couldn't make it. I thought let me check if any videos available in youtube and I found your video.

Your video was very helpful to me. Now I completed that task successfully. Thank you very much for taking time in designing and uploading for us.

acutually i got stuck in flat file connection manager, where we need to go to properties window and select property as "connection string" and assign variable.

Thanks for your videos.

[creativecommIT]

@praveenadigopula Glad that I could be of help

[Tilosag]

Very good job bro! I appreciate it!

[vnansen]

can achieve the same processes for the xml file too ?

[sharmaindresh]

use just used a .txt file to push data into sql table, same we can use .xls file in place of .txt file right, but in this example you just copy thr .txt file just imagin if we have different .txt file with different data then it should puch all .txt file data or just push data from pnly the file we choose to make flate file connection not frm other files, becoz i used same way for .xls file and it just copy the data from first file not from other .xlx file each time.

[creativecommIT]

@sharmaindresh Loop in all files in a directory, and one by one loads the contents to DB.

[hufnmouth]

What software did you use to create this video?

[goofball4eva]

In a scenario where you have a number of rows selected in a result set from DB A and want to manipulate tables according to that data in DB B. Could you use foreach to iterate through them? If so, could you give provide some info.