101 How to upload files to sftp server using script task in SSIS

101 How to upload files to sftp server using script task in SSIS

Learn SSIS

1 год назад

5,986 Просмотров

Ссылки и html тэги не поддерживаются


Комментарии:

Muhsin Ali
Muhsin Ali - 04.10.2023 02:22

Hi Aqil, Thank you for the wonderful tutorial. Somtime it's working fine and sometime I am facing the the below issue while execute this script. can you please help me out. thanks
Below is the ErrorLog

Renci.SshNet.Common.SshConnectionException: An established connection was aborted by the server.
at Renci.SshNet.Session.WaitOnHandle(WaitHandle waitHandle, TimeSpan timeout)
at Renci.SshNet.Session.WaitOnHandle(WaitHandle waitHandle)
at Renci.SshNet.Session.Connect()
at Renci.SshNet.BaseClient.CreateAndConnectSession()
at Renci.SshNet.BaseClient.Connect()
at ST_eab6f1da82a04a9aaa42d2164cde9f1d.ScriptMain.FileUploadSFTP()
at ST_eab6f1da82a04a9aaa42d2164cde9f1d.ScriptMain.Main()

Ответить
21Amorales
21Amorales - 13.09.2023 21:48

Excelente, muchas gracias. tenia todo menos el registro de la librería. Luego de eso. me funcionó perfecto!

Ответить
Annaso Gejage
Annaso Gejage - 07.09.2023 12:52

It has been working on visual studio 2017?

Ответить
MoveOutMedia
MoveOutMedia - 30.05.2023 21:05

This was amazing. Thank you so much for the solution. It’s the registration piece that I used. I knew my code is right, but it would not work until I registered it in the GAC.

Ответить
Yujan
Yujan - 06.04.2023 06:49

Hi, I need to do this for work and its not possible to register dll in computers. Is there any other way to do it?

Ответить
Achref Laayouni
Achref Laayouni - 21.03.2023 01:26

THANKS alot man you saved me a ton of time

Ответить
Mahamutha Shameem
Mahamutha Shameem - 01.02.2023 17:58

thanks a lot for the video. I was frustuated to fix the assembly issue

Ответить
Ricardo PSSouza
Ricardo PSSouza - 21.01.2023 15:36

A little Brazilian thanks you for the video

Ответить
Deepak J
Deepak J - 05.12.2022 19:53

Hi Aqil, I'm facing a problem. In production one SSIS package is running from last 4-5 hours which usually takes 10-15 mins to complete. How to resolve/troubleshoot this issue. What is use of sp_whoisactive?
Pls try to make video on SP_WHOSISACTIVE.
Thank you for all your videos, your videos are really helpful to learn concept in short time !! 👍

Ответить
Frank Do
Frank Do - 05.12.2022 05:29

wow ..You're incredibly good. I would not be able to fix the GAC/SN assembly things without watching your video .. Thank you so much Aqil .. 👍🙂

Ответить