on 2015 Jun 18 6:48 PM
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.
Thanks
Magge
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thank you Dirk .You are perfectly right .Now i have used the IP address and now i made 50 percent progress and now i can able to preview the data that means , now it is connecting to FTP .But
when i schedule the job it's throwing out error "FTP Could not transfer the File" as attached below.
Any setting needs to be made on the server.
Thank you for your help.
Magge
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
User | Count |
---|---|
67 | |
8 | |
8 | |
6 | |
6 | |
6 | |
6 | |
6 | |
5 | |
5 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.