FTP connection

[former_member186356]

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

[former_member186356 · Accepted solution]

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.

[former_member187605 · Accepted solution]

The error message is not about ftp ports not being open, it's about host name not resolvable. Use IP address instead, or fully-qualified name. And try it from the command line first.

On another note, why do you hide the server name in one screenshot? And display it in the next???

[former_member186356 · Accepted solution]

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

[former_member187605 · Accepted solution]

I can only repeat: try from the command line first.

[former_member186356 · Accepted solution]

Thank you Dirk.Now the issue is resolved . Since data services first copies the file from FTP

location to Local folder , i need to give the local shared folder accessible to Data services in the 'Directory' of Format tab.Now the issue is resolved . Thank you for the answers.

Thanks

Magge

[Former Member · Accepted solution]

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