Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SSIS package to import from Excel
Message
 
 
To
13/07/2022 21:46:39
General information
Forum:
Microsoft SQL Server
Category:
Import/Export
Miscellaneous
Thread ID:
01684637
Message ID:
01684654
Views:
34
>>Hi everybody,
>>
>>I'm wondering what are my options of using an SSIS package to read data from Excel without having Excel installed on the server? The package is executed as part of the job. Is there an easy way to convert Excel to csv (say, using Powershell script (but without Excel installed, so no COM automation)) or as a .NET script task?
>>
>>Do you have ideas?
>>
>>Thanks in advance.
>
>>>NET script task?
>I haven't done much with it, but C# using OpenXml can read a spreadsheet without Excel being present.

OpenXML needs to be installed, right? Can you clarify how exactly this should be installed?

Thanks in advance.
If it's not broken, fix it until it is.


My Blog
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform