SSIS 2008 Series: The For-Each Enumerator

This demonstration gives a basic overview of how to use the for-each enumerator

Category:

Science & Technology

Tags:

• sql
• server
• 2008
• integrationservices
• business
• intelligence
• microsoft
• integration
• services
• video
• training
• ssis

[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

[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

[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.

[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!

[anuragydv]

Thanks a lot Rajesh

[mynameheman]

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

[Tilosag]

Very good job bro! I appreciate it!

[vnansen]

can achieve the same processes for the xml file too ?