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.
@hanumishra55902 ай бұрын
Hello I am working as an SQL developer I wanna learn SSIS Services Which play list of urs should I follow
@learnssis2 ай бұрын
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