162 How to get the record count of a file in SSIS

[@tusharjadhav2589]

Hi bro, I receive a task from where they want to load only latest date file to SQL server from FTP Server.
How can we fetch only latest date file from FTP? using SSIS

[@learnssis]

These are the 2 videos on downloading files from sftp server. In first one we are using batch file to download the file, in second video we are using C# code to download the file from SFTP server. In second video you can check the lastmodifieddate of a file and according to that you can download that file.
th-cam.com/video/yVSvKZcDSUY/w-d-xo.html
th-cam.com/video/2HdpMMPMo1A/w-d-xo.html
In this video you can get the most recent file from a folder.
th-cam.com/video/O1xVlKq8cqY/w-d-xo.html
So you need to modify the code as per your requirement. Once the file is downloaded from ftp server, then you can easily import it to sql server using a data flow task.

[@hanumishra5590]

Hello I am working as an SQL developer
I wanna learn SSIS Services
Which play list of urs should I follow

[@learnssis]

SSIS Tutorials: th-cam.com/play/PL_YF--8vjjEVEXMf2hEFn0D5tEJV9kRqi.html
SSIS real time scenarios examples: th-cam.com/play/PL_YF--8vjjEU1Hdlqp2U_q0JNyFPYUIKY.html
SSIS Interview questions and answers: th-cam.com/play/PL_YF--8vjjEVYkoxioTCEKAkBxjLEUUB7.html