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
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.
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
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
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.
Hello I am working as an SQL developer
I wanna learn SSIS Services
Which play list of urs should I follow
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