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. kzbin.info/www/bejne/r4e2p36QmKmGi7s kzbin.info/www/bejne/aHnHoYCDhbKiZ6M In this video you can get the most recent file from a folder. kzbin.info/www/bejne/hWLbh5-Bpp2Wp7s 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: kzbin.info/aero/PL_YF--8vjjEVEXMf2hEFn0D5tEJV9kRqi SSIS real time scenarios examples: kzbin.info/aero/PL_YF--8vjjEU1Hdlqp2U_q0JNyFPYUIKY SSIS Interview questions and answers: kzbin.info/aero/PL_YF--8vjjEVYkoxioTCEKAkBxjLEUUB7