cancel
Showing results for 
Search instead for 
Did you mean: 

Excel file load in Data services

former_member186356
Participant
0 Kudos

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

View Entire Topic
former_member186356
Participant
0 Kudos

Thank you  Sevrin Nawfal Arun. We tried /do have all settings as you all mentioned , but for some reason i am unable to access the files . I think it's beyound the developer settings. I will request the Basis and linux team to check this issue. Thank you for all your answers.

Thanks

Magge

former_member198401
Active Contributor
0 Kudos

Hi Magge,

I hope the Basis and Unix team crack the issue. DS Job server on the unix server is a nightmare.

Let us know if the issue is resolved and the solution. :

Regards

Arun Sasi

former_member186356
Participant
0 Kudos

Arun,

You are 1000 % right , we are having issues one after the other since the DS is on the unix and each is taking more than a week to fix .Yes , i will list out all the issues and solutions once it is done.

Thanks

Magge

former_member198401
Active Contributor
0 Kudos

Yes Magge!!

Its really a nightmare to solve the issues related to DS Job Server on Unix. But if you have a well qualified DS Unix Administrator then your life will be easy

Regards

Arun Sasi

former_member186356
Participant
0 Kudos

Hi Arun & All,

We could not able to fix the issue. So now we moved the data services from Unix to Windows.

Thank you for all your answers.

Thanks

Magge