not able to write SQL command for ODBC source in SSDT 2017

Sree 11 Reputation points

Hi All,

I am using SSDT 2017 and trying to write SQL query in ODBC source. But I cannot see the SQL query pane itself.
Could some on throw some light on this issue please.

PFB screenshot.

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,467 questions
{count} vote

1 answer

Sort by: Most helpful
  1. Monalv-MSFT 5,896 Reputation points

    Hi @Sree ,

    1.Please check if you set the ODBC Connection Manager correctly.

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

    3.Please delete the ODBC source and the ODBC Connection Manager and then recreate them.

    Best Regards,

    If the answer is helpful, please click "Accept Answer" and upvote it.
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.