How to upload excel file using SSIS with out Excel installed on thes erver

Hi experts,

  Trying to upload excel in server where excel is not installed. BIDs was there in the server, when i am trying to craete Excel source I am not able.

what the workround for this.. How to upload excel without excel installed on the server.pls guide me.

July 25th, 2015 3:54am

Good day Dev

Please clarify:

First you talk about "upload excel in server". Do you mean that you want to import data from Excel to SQL Server?

Secondly you are talking about "i am trying to create Excel source" which is not clear to me what you mean. Do you want to create the Excel or use Excel file?

Free Windows Admin Tool Kit Click here and download it now
July 26th, 2015 2:52am

You need to have excel provider installed in the server if you want to use BIDs in server to upload excel data.
July 26th, 2015 3:12am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics