Script Task SSIS Example C# | Read File Extensions using Script Task C#

Published: 22 April 2021
on channel: Gurunatha D
2,377
49

#SSISScriptTask #ScriptTask

In this video we have demonstrated multiple files in a folder having like "Text" and "Excel" and for ETL process we created to Data Flow Task, One for Excel and One for Text File with Flat file Connection and Excel Source Connection.

Now to get each file from a folder we implemented For-Each Loop Container and each file with Full Qualified Name is been passed to Script Task and by using variables and by using Microsoft C# Code System.IO namespace we read the particular file extension and by expression we redirected file to its respected Data Flow Task and further we did ETL process.


On this page of the site you can watch the video online Script Task SSIS Example C# | Read File Extensions using Script Task C# with a duration of hours minute second in good quality, which was uploaded by the user Gurunatha D 22 April 2021, share the link with friends and acquaintances, this video has already been watched 2,377 times on youtube and it was liked by 49 viewers. Enjoy your viewing!