Link to home
Start Free TrialLog in
Avatar of rwheeler23
rwheeler23Flag for United States of America

asked on

Using SSIS to import and export to an SFTP site

I have created SQL scripts using MSSQL Server 2019 that import and export data using text csv files. This was to prove the correct data was being used. I now have to automate this process. The client has set up an SFTP site and I have the necessary credentials. Is this something that SSIS will be able to do or will I need some other application? On the export side I will be executing a SQL script and need the results to be sent to a csv file which will then be forwarded to the SFTP server. On the import side I will be reading a csv file and inserting data into SQL.
ASKER CERTIFIED SOLUTION
Avatar of lcohan
lcohan
Flag of Canada image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial