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.
Add a comment