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

Sree 11 Reputation points
2021-01-22T11:29:58.787+00:00

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.
59488-image.png

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
    2021-01-25T08:15:31.31+00:00

    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.
    60059-df.png
    60105-odbc-source.png
    60127-setodbcsource-sqlcommand.png

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

    Best Regards,
    Mona


    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.
    https://learn.microsoft.com/en-us/answers/articles/67444/email-notifications.html