SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,700 questions
VS2022 SSIS cannot load ODBC data column
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(3.2, 99%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAW%3C/text%3E%3C/svg%3E)
Angi Wang
0
Reputation points
Hi
I'm trying to use VS 2022 Community SSIS to connect some ODBC data sources like SAP Hana or SQL Server 2022.
I can see the table and data in Preview page, but cannot see any data columns in the "data column setting", any ideas about this?
I can use the same ODBC connection (SAP Hana or SQL Server 2022) to load data into Power BI Desktop in the same Window Server.
The OS and software list as below:
- Windows Server 2025 Standard 10.0 <X64> (Build 26100: ) (Hypervisor)
- Microsoft SQL Server 2022 (RTM) - 16.0.1000.6 (X64) Standard Edition
- Visual Studio 2022 Community
- ODBC driver 18 for SQL Server
- SAP HANA ODBC driver 2.24.26.14707
SQL Server Integration Services
{count} votes
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(96, 26%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EYK%3C/text%3E%3C/svg%3E)
Yitzhak Khabinsky 26,576 Reputation points2025-06-17T12:15:39.94+00:00 I would suggest to try VS2019, and repeat the exercise.
Sign in to comment
Sign in to answer