PC SOFT

FORUMS PROFESSIONNELS
WINDEVWEBDEV et WINDEV Mobile

Accueil → WINDEV 2024 → Importing data from HFSQL with SQL Server Integration Services SSIS
Importing data from HFSQL with SQL Server Integration Services SSIS
Débuté par Jorn Leyssens, 23 juil. 2025 19:54 - Aucune réponse
Posté le 23 juillet 2025 - 19:54
Hi all,

(not sure whether this is the right place to put this question)
I'm using the 30.0 OLE DB driver to import data from a HFSQL database with SSIS. Whenever I open the package and it tries to validate, it crashes.
After some trouble 6 years ago, It was working with version 15.0 for many years, but not we are upgrading to SQL server 2022, and it looks like we are getting into the same scenario again.

Currently I see 2 solutions:
- Use it as a Native OLE DB connection in SSIS (preferred)
- Create a Linked Server, pointing to the HFSQL database

Any help is much appreciated. Let me know if more information is needed.

Thanks!