Skip to Content

FTP connection

Hello Gurus,

I would like to load the file from FTP server into SQL server Database. I read some of the threads that it is not a straight

Forward process. We need to do the below following. I am new to Data services .Not sure where to write the code. If it is not straight forward and why there is an option, in the File-Data access tab for FTP Connectivity in Data services. I have gone through the posts, I did not find any step by step documents to load the file from FTP to Target.

Objective: File is in FTP and need to be move to Target (SQL Server). What are step by step that need to be done along with the Code.

  1. 1. Create a flat file format and use it as your target in the data flow
  2. 2. Create a .cmd/.bat script which calls the ftp command with all your actions needed (e.g. change into the correct directory on server and so on)
  3. 3. Use this .cmd script as Custom Transfer Program in your file target or alternatively call the .cmd in a BODS-script after having written the file.

Thanks

Magge

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • Best Answer
    Posted on Jun 18, 2015 at 06:35 PM

    Gurus,

    Just wanted to Add, When i tried to Connect : Formats Tab: Excel work books : And it is throwing error unable to connect :

    Error Message ;

    Failed to establish FTP session to host <ftp://-----/ServiceNowFTPIn>. Error: <The server name or address could not be resolved

    >.

    The data services is on windows and it seems the FTP Ports are open . Basis confirmed.

    Attached is the screen shot.


    Error1.jpg (134.1 kB)
    error2.jpg (130.8 kB)
    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Dirk Venken

      Hi Dirk,

      I have the same problem. unable to resolve the HOST.

      I did try to ping and it works fine. I am able to login using SAP LOGIN and the account works fine.

      Another question i have is apart from the RFC connection in ECC, do i need to setup RFC in the BODS Management console? I was told that the RFC connection in BODS management console is for SAP BW. Correct me if my information in wrong.

      Any suggestions please

      Thanks,

      Ashok

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.