![]() I'm trying to use the "Execute Process Task" in SSIS to use a command line prompt to use PuTTY that way. I've been given a username and password as well as an IP address and port number for the vendor's FTP site. I'm learning what I can from the help files. I have never used it and don't understand it. I downloaded and installed PuTTY on my local client PC. The vendor will only allow a connection from a secure FTP site, so I can't use the regular FTP task from inside SSIS. I'm using SSIS to connect to my student information system db, extract 4 csv files of information and then FTP those csv files to a third-party vendor. There's no need to tell me I don't know what I'm doing since I readily admitted it. I thought I made it obvious that I don't know what I'm doing when it comes to FTP. I just realized that I misunderstood Duvall's original post of running SFTP from his PC against a scheduled job, that changes my answer a bit. I'm going to have to do another PuTTY fingerprint addition probably by the end of the year and another one a couple of months after that. The fingerprint will be saved with the myproxyuser's profile. That will open a command prompt as your proxy account open Task Manager and you can see that the User name for that command prompt has changed. You can save the fingerprint by using PSEXEC on your workstation. You want to call the pscp or psftp from a scheduled job on you workstation. If I understand this, you have SQL Server Agent running on a server and on your workstation. In any case, how can I do this proxy account thing? Any help is very much appreciated. I'd rather install it on the server, but my network admin won't let me. 6.Can someone explain specifically how to create the proxy account so that the fingerprint is stored? I'm going to be running this from SQL Server Agent scheduled jobs, but the Putty program is installed on my local PC.6.2.19 The ! command: run a local Windows command.6.2.18 The mv command: move and rename remote files.6.2.17 The rmdir command: remove remote directories.6.2.16 The mkdir command: create remote directories.6.2.15 The del command: delete remote files.6.2.14 The chmod command: change permissions on remote files.6.2.13 The dir command: list remote files.6.2.12 The reget and reput commands: resuming file transfers.6.2.11 The mget and mput commands: fetch or send multiple files.6.2.10 The put command: send a file to the server.6.2.9 The get command: fetch a file from the server.6.2.8 The lcd and lpwd commands: changing the local working directory.6.2.7 The cd and pwd commands: changing the remote working directory.6.2.6 The help command: get quick online help.6.2.5 The close command: close your connection.6.2.4 The quit command: end your session. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |