Excel file load in Data services

[#1]

Hi Experts ,

I am trying to load the simple excel/ XLS/XLSX  or CSV file in to SQL server  using the data services. I have read many threads and they say that

if the file is on my desktop i can not upload the file in to the target using the data services . It has to be on the server .

1) How to keep the file on the server , i have asked basis team to keep the file on the server and they put it on the server and still i f i look at the log , it is unable to locate the file.

Why i can not upload the file from my desk top . How to keep the file in the folder that is accessible to the job server .

If i keep the file in the job server how does it knows the file structure . Do i still need to keep the file on the Desk top to get the structure.

What it means the "The file should be accessible to the Job server " how do i access this folder or location "   every time with out asking any ones (Basis Admin)  help. How to keep the file on the server.

2) I am trying to load the file from  FTP WINSCP  using the data services in to SQL server . Mu source file is in FTP-WINSCP and target will be

SQL server .  I am trying  to create the FTP connection using the Data access tab.  I tried different entries /connection parameters . Is there

any thing that we would like to consider since it is not working.

Thanks

Magge

[Former Member]

Hi,

What I can suggest is that you have 2 copies of the same source  file, one local to your client desktop and one on your job server on the Unix  server. During the development phase you create a new  file format in the local objects library and specify the location of the file to be local. With this method you can get/import and change the file format definition if necessary  and preview content. Once satisfied with the format  you should change the location of the file from "local" to  "job server" and specify the Unix path where the file resides. Make sure that the Data Services user has at least read access to the file. When executing a job, the job server will pickup the file located on the server and reads it as a source.

Regards

Nawfal