#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.
Nesta página do site você pode assistir ao vídeo on-line Script Task SSIS Example C# | Read File Extensions using Script Task C# duração hora minuto segundo em boa qualidade , que foi baixado pelo usuário Gurunatha D 22 Abril 2021, compartilhe o link com seus amigos e conhecidos, no youtube este vídeo já foi visto 2,377 vezes e gostou 49 espectadores. Boa visualização!