Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
SSIS package to import from Excel
Message
De
13/07/2022 21:46:39
 
 
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Import/Export
Divers
Thread ID:
01684637
Message ID:
01684652
Vues:
53
This message has been marked as a message which has helped to the initial question of the thread.
>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.
Anyone who does not go overboard- deserves to.
Malcolm Forbes, Sr.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform