SQL Server: SFTP with SSIS Execute Process Task

Who is online?  194 guests and 0 members
home  »  blogs  »  Raunak Jhawar  »  SQL Server: SFTP with SSIS Execute Process Task
  Rate This Blog Entry:  register  or  login

Author

raunak.jhawar Raunak Jhawar (Member since: 7/12/2011 6:42:24 AM)
Specilaist for Intensive Data Computing.

View Raunak Jhawar 's profile

Comments (5)

user469543
2/23/2012 10:28:17 PM user469543  said:

 

very good, now as in the case would upload the file to sftp. thank you very much
by
user509689
9/14/2012 7:12:53 AM user509689  said:

After doing the above steps,my package is executing fine,but the desired result (recieve files from remote path to local machine) is not achieved.

when i run my script in the command prompt,it runs fine and establishes connection to my sftp server.i've also set me WorkingDirectory to the same path as my WinSCP executable.

Am i missing something?

by
raunak.jhawar
9/17/2012 6:03:25 AM Raunak Jhawar said:

How are you executing the package?

by
user509689
9/18/2012 3:07:41 PM user509689  said:

Hi Raunak,

I'm passing the Winscp exe file  (C:\program files) path in "Executable" 

Specifying the folder path in which my txt/bat file in "Arguments"

lastly,the working directory is set to a folder on my local machine.

Am i missing something here?its exactly the same as you've mentioned in your blog above.

Thx in advance for your help

Appreciated

by
user381905
6/26/2013 4:51:56 AM user381905  said:

Hi, 

Can we directly read a csv file from SFTP location without downloading to local system from SSIS? I can use FTP task component but it will download files from FTP location. My requirement is to read files from SFTP location without downloadinng them elsewhere due to confidentiality/misuse of data.

Regards,

Chaitanya

by

Leave a comment


 
Type the characters:
 *
 
   

SQLServerGeeks FaceBook group

SQLServerGeeks Events

Training on Microsoft Products & Technologies

Email Subscriptions

   Get the Most Recent Blogs in your inbox
Blogs RSS Feed

Raunak Jhawar's latest blog posts

Blogs RSS Feed

Latest community blog posts

  • Hi Friends, In my earlier blog, I just explain about the importance of filtered indexes. Link for that blog is mention below: http://sqlservergeeks.com/blogs/princerastogi/personal/599/filtered-indexe...
  • A few words about the technology of our site. It's easy to take technology for granted, to focus on content and pay no attention to how it is being delivered. Typically we would encourage this focus. ...
  • Hello, Constraints can be defined as rules that govern the values that are inserted into a column. These rules help in enforcing data integrity. For example if a NOT NULL constraint is defined over a ...