Share via

Sql Server Data Tools not showing option to enter sql in ODBC Data source

Greg Booth 1,416 Reputation points
2023-02-14T09:45:01.3333333+00:00

We are using Visual Studio 2019, with SSDT component - Sql serverr integration services 15.0.20000.180.

When we create a new package , create a data flow and add a new ODBC data source,

Data Access mode = SQL Command, the box to enter the actual SQL command does not appear.

SQL Server Integration Services
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. ZoeHui-MSFT 41,536 Reputation points
    2023-02-15T02:11:45.3733333+00:00

    Hi @Greg Booth

    1.Please try to set the Run64bitRuntime to false.

    2.Please set the Sql Command of ODBC source in the properties of Data Flow Task by choosing DFT.

    Untitled

    3.Also try to delete the ODBC source and the ODBC Connection Manager and then recreate it.

    If these do not work, try to repair VS and restart VS.

    Regards，

    Zoe Hui

    If the answer is helpful, please click "Accept Answer" and upvote it.

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.