Get the file name from file path in SSIS and insert into SQL table | SSIS real time scenarios
Dts.Variables["FileName"].Value = System.IO.Path.GetFileName(Dts.Variables["FilePath"].Value.ToString());

Download the file\script used in the Video from below link
[ Ссылка ]
SSIS Tutorials: [ Ссылка ]
SSIS real time scenarios examples: [ Ссылка ]
SSIS Interview questions and answers: [ Ссылка ]

Get the file name from file path in SSIS and insert into SQL table
How do I find the filename in SSIS?
How do I import a filename into SSIS?
How do I get the filename in SQL?
How would you save file names from different folders in a SQL Server table?

If you have any questions or suggestions please comment on the video or write to me at “aqil33@gmail.com”

свернуть