133 Explaining Foreach loop container options in detail in ssis

Подписаться 34 тыс.

Просмотров 4,4 тыс.

50% 1

Explaining Foreach loop container options in detail in ssis
drive.google.c...
SSIS Tutorials: • SSIS Tutorials
SSIS real time scenarios examples: • SSIS real time scenari...
SSIS Interview questions and answers: • SSIS Interview questio...
foreach loop container options in ssis
foreach loop container with file enumerator in ssis
What is the difference between For Loop container and foreach loop container in SSIS?
How many types of loop containers are there in SSIS?
What are the types of SSIS containers explain?
Happy Learning.
If you have any questions or suggestions please comment on the video or write to me at “aqil33@gmail.com”

Опубликовано:

15 окт 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 20

@syedsirajahmad2012 4 месяца назад

Thanks brother, this video help me in implement my SSIS package. Its very useful.

@learnssis 4 месяца назад

You are most welcome brother.

@darrylw99 4 месяца назад

Great video, how can I use the filename to insert into a table, to store that the file has been used?

@learnssis 4 месяца назад

You can take a look at this video. ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-75hI04cbkx0.html

@prashanthtalla 2 месяца назад

Thanks man. Assuming that the target is a database table, how to change this logic to read the files in parallel and load into the target in parallel instead of sequentially? The actual requirement is a SQL task prior to the Foreach Loop is feeding a list of databases against which same SQL has to be run in parallel (as the SQL runs for a long time) on all the databases that the Foreach Loop receives and the data extracted from each database should be loaded to the same target table in the target database.

@learnssis 2 месяца назад

You can create a kind of Configuration table and add a column like Thread. Now if you want to run 100 tasks, and you want to create 4 thread for 100 tasks, then you can use ntile function in sql to split the 100 tasks into 4 thread, thus for thread column the value will be 1 for 25 task, same way value will be 2 for next 25 task and so on. Now you can use 4 foreach loop container and in the select query before each foreach loop container we can write a condition (foreach loop container 1), select * from configurationtable where thread=1 (foreach loop container 2), select * from configurationtable where thread=2 and so on.

@prashanthtalla 2 месяца назад

@@learnssis Thank you for such a quick reply. I am not sure if I fully understand this but I will try to change the logic as you suggested and see. If you could do a video on this, I will be super thankful to you.

@learnssis 2 месяца назад

@@prashanthtalla Read about the ntile function in sql server. Using Ntile function you can divide the rows into equal smaller parts. And now multiple foreach loop container can work parallelly. One foreach loop on one part.

@manjunathmanju8320 7 месяцев назад

Hi your videos are very useful to me, I have a doubt that if I have a folder containing many files I need to move only a certain name files, is this possible with this, could you please explain to me.

@learnssis 7 месяцев назад

If you want to move specific types of files from one folder to another then you can use foreach loop container along with file system task to do the same ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-IbieDAatf5M.html

@sureshareti2843 Год назад

Good one bhaiyya thanku

@learnssis Год назад

Thank you Bhai.

@vankadarinikhil1317 9 месяцев назад

Hi Sir - I have one question in SSIS we can use check points in For each loop container,For loop container & Sequence container

@learnssis 9 месяцев назад

You can not put the checkpoint in for loop or foreach loop container, however you can try using the checkpoint in sequence container. For sequence container the checkpoint should work.

@vankadarinikhil1317 9 месяцев назад

@@learnssis thank you

@SVSV-g7c 11 месяцев назад

Hi I have an issue with for each loop container that is not getting resolved. After I set the variables and try to load mutliple excel files from one folder to sql table. There is an error popping up saying.....Error: the connection string format is not valid. It must consist of one or more components of the form X=Y separated by semicolons. This error occurs when a connection string with zero components is set on database connection manager. The result of the expression "@[User:FP] on property "\Package.Connections[Excel Connection Manager].Properties[ConnectionString]" cannot be writen to the property. The expression was evaluated but cannot be set on the property. Also my table is getting loaded with the same first file mutliple times(5 times) . I have 3 excel files in the folder. I am quite unsure why the loop is not iterating and why the first file gets loaded 5 times. Please help me here. Thanks!

@learnssis 11 месяцев назад

If you are trying to load the multiple excel files, then in the excel connection manager instead of setting the connection manager property dynamically you should set the "ExcelFilePath" property dynamically. ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-TH9ptAkCHNA.html

@remek5758 Год назад

Hi, Do you have any videos that cover loading data from sql server or any other source - in dest they should create Dim Tables and fact Table, Lets say Dim Table would be Product/Customer/Other(?) and Fact table Sales? It would be great if you could cover a way to create surrogate keys (lets say that in source file we dont have an ID but some text value as primary key) then fact table should store data based on surrogate keys and not text

@learnssis Год назад

below are the videos on loading data to Dim and Fact tables. ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-c2lSKLQPb_I.html ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-duaR_PhLdmc.html

@remek5758 Год назад

@@learnssis Thanks