title: Informatica Cloud - Picking up files from SFTP and inserting records in Salesforce
body: <p>Our objective is as follows</p>
  
  <p>a) Pick up a file "Test.csv" from a Secure FTP location.</p>
  
  <p>b) After picking up the file we need to insert the contents of the file into an object in Salesforce.</p>
  
  <p>I created the following connection for the Remote SFTP (the location which will contain "Test.csv")</p>
  
  <p><a href="https://i.stack.imgur.com/QNbGh.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/QNbGh.png" alt="enter image description here"></a></p>
  
  <p>Step 1</p>
  
  <p>This is as shown below</p>
  
  <p><a href="https://i.stack.imgur.com/xXdLL.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/xXdLL.png" alt="enter image description here"></a></p>
  
  <p>Step 2</p>
  
  <p>Then I started to build a Data Synchronization Task as below</p>
  
  <p><a href="https://i.stack.imgur.com/lLE9l.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/lLE9l.png" alt="enter image description here"></a></p>
  
  <p>What we want is for the Informatica Cloud to connect to the secure FTP location and extract the contents from a .csv from that location into our object in Salesforce.</p>
  
  <p>But as you can see in Step 2, it does not allow me to choose .csv from that remote location.</p>
  
  <p>Instead the wizard prompts me to choose a file from a local directory (which is my machine ...where the secure agent is running) and this is not what I want </p>
  
  <p>What should I do in this scenario ?</p>
  
  <p>Can someone help ?</p>