130 FTP Task in SSIS

FTP Task in SSIS
Download the file\script used in the Video from below link
drive.google.com/drive/folder...
SSIS Tutorials: • SSIS Tutorials
SSIS real time scenarios examples: • SSIS real time scenari...
SSIS Interview questions and answers: • SSIS Interview questio...
FTP Task in SSIS
What is an FTP task?
What is FTP in SQL?
What is FTP and what does it stand for?
ssis ftp task receive files
What is FTP Task How do you use FTP task?
How do I fetch a file from FTP and import into SQL Server automatically?
How do I download an FTP server from SSIS?
How do I download a folder from an FTP server?
If you have any questions or suggestions please comment on the video or write to me at “[e-mail]”

[@deepakj6717]

Hi Aqil, Nice explanation.. Thank you!!
Explain any complex scenario you have worked on in SSIS? this is mostly asked interview question. Pls try to make video on this.

[@learnssis]

Thanks, Sure. I will try to make a video on it soon.

[@user-qs1cc6fq9y]

Hi Aqil, Amazing, your all video really appreciated.could you please help me on this to extract data from staging tables to partitioned tables with incremental load ?please suggest with example in SSIS.
Thanks in advance.

[@learnssis]

Hi, I have a video on loading data from sql staging table to another sql table with incremental load
th-cam.com/video/8dRIjVhKoKs/w-d-xo.html
If you want to learn about table partitioning then you can go through this blog
www.sqlshack.com/how-to-automate-table-partitioning-in-sql-server/
And can watch this video on sql server table partitioning
th-cam.com/video/Rxu3IenrMBI/w-d-xo.html

[@user-qs1cc6fq9y]

@@learnssis thanks a lot ..but if you create a video related to staging table to partition table using SSIS ,it will be really appreciated.
Actually ,I tried but not able to design the SSIS package.
Request you to please create and share the SSIS package related this.
Thanks in advance and really appreciated your support.

[@nehadhawan3441]

Hello sir, thank you so much for this informative video. Just 1 question pls...
Is this feature of SSIS FTP Task also available if we are using Azure SQL server instead of the SQL on-prem server ?

[@learnssis]

This is available in SSIS. And SSIS can be installed with SQL On premises only, although you can insert the data to Azure sql server as well from SSIS, but it will executed from a machine where SQL On-Premises is installed.

[@nehadhawan3441]

@@learnssis Okay sir, thank you so much for this clarification. Kind Regards

[@aanchalsrivastava8550]

Hello just one thing I have encountered one situation in left outer join that to join two tables we can use different columns meaning when applying on condition is it possible can u take example and show

[@learnssis]

Yeah you can join on any columns from both tables and even you can join on multiple columns as well, I am actually planning to create a whole tutorials on SQL language from start to end so that it will cover all joins and all topics in it.

[@aanchalsrivastava8550]

@@learnssis Can u just create one scenario on this by tomorrow

[@learnssis]

@@aanchalsrivastava8550 Sorry at the moment I am working on another video.

[@learner_SSIS]

Thank you for your explanation sir 😀
how do Using SFTP in ssis , our client has SFTP server sir

[@tusharshinde3905]

Please make video on transfer files from SFTP folder... I'm waiting for it

[@learnssis]

Yeah will try to make a video on that one as well.

[@user-xz9bz8nj9r]

can we use Same Task component for SFTP Servers ?

[@learnssis]

No, we can't do that.

[@pvksmaheeth8816]

Have you ever used Task Factory ?

[@learnssis]

Do you mean the third party components ?

[@pvksmaheeth8816]

@@learnssis Yes , For Insert and Update one component

[@learnssis]

@@pvksmaheeth8816 Yes I have used it.
In SSIS you can do this using below method if you don't want to buy a license for it
th-cam.com/video/8dRIjVhKoKs/w-d-xo.html

[@learner_SSIS]

Hi sir,
how to Using SFTP server in ssis script task via move file from local folder to SFTP server folder because my client has SFTP server sir,

[@learnssis]

First I will try to install SFTP Server on my windows 10 machine and then I will work on to upload and download the files to and from SFTP Server.

[@learner_SSIS]

@@learnssis thank you sir 👍