locked
How to run the command dtexec RRS feed

  • Question

  • I have a bat job , that was prepared by my previous colleague , this bat job is used to export data from SQL database.

    The batch is dtexec /f ... , but I found that my PC do not have the command file dtexec.exe , I tried to install , SQL server 2008 express , MS visual studio but still not found dtexec.exe .

    Would advise how can I run dtexec , what application that I need to install ?

    Thanks

    Monday, January 6, 2020 2:51 PM

All replies

  • You haven't mentioned what version of SQL server you are running. Run setup and install the client tools. It is installed with them.
    Monday, January 6, 2020 3:41 PM
  • You haven't mentioned what version of SQL server you are running. Run setup and install the client tools. It is installed with them.

    I use SQL express server 2008 

    what tool that I need to install ?

    Tuesday, January 7, 2020 1:15 AM
  • Hi sir,

    Normally, the DTEXEC could be found this way: 

    It needs to install any version of SQL Server ( the picture showed is SQL Server2019).

    Best Regards,

    Lily


    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com

    Tuesday, January 7, 2020 1:45 AM
  • Hi sir,

    Normally, the DTEXEC could be found this way: 

    It needs to install any version of SQL Server ( the picture showed is SQL Server2019).

    Best Regards,

    Lily


    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com


    thanks reply 

    you mean the file dtexec.exe will be available after installed the SQL server express 2008 ? 

    Tuesday, January 7, 2020 3:29 AM
  • Hi Derek Chan 456,

    May I ask if there are some reasons you must install SQL Server 2008 express? 

    DTEXEC is easy to be found in either SQL Server 2017 or 2019 file packet after you complete the installation.

    Here is the link to install.

    Best Regards,

    Lily


    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com


    • Edited by Lily Lii Tuesday, January 7, 2020 5:33 AM
    Tuesday, January 7, 2020 5:04 AM
  • Hi Derek Chan 456,

    May I ask if there are some reasons you must install SQL Server 2008 express? 

    DTEXEC is easy to be found in either SQL Server 2017 or 2019 file packet after you complete the installation.

    Here is the link to install.

    Best Regards,

    Lily


    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com


        My SQL is running sql server express 2008 , therefore , what tool ( any version , any application ) should be installed , so that I can use dtexec , is SQL Server 2017 or 2019 should be installed on client side ?

    Tuesday, January 7, 2020 5:37 AM
  • Hi Derek Chan 456,

    As far as I know, SQL Express does not include DTEXEC, you may install SQL Server 2019 on your client server.

    Just advice, extended support for SQL Server 2008 ended on July 9, 2019, Microsoft team will no longer release security updates and provide the support for any version of SQL Server 2008, so I suggest you update your SQL Server version to the newest soon.

    Also you may use the corresponding version SSIS to connect to SQL Express.

    Best Regards,

    Lily


    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com


    • Edited by Lily Lii Tuesday, January 7, 2020 7:16 AM
    • Proposed as answer by Lily Lii Wednesday, January 8, 2020 6:23 AM
    Tuesday, January 7, 2020 6:03 AM
  • Hi Derek Chan 456,

    May I ask that if your issue has been solved? Please feel free to let us know if you have any other question.

    If you have solved your issue ,in order to close this thread, please kindly mark helpful replies as answers. By doing so, it will benefit all community members who are having this similar issue.

    Best Regards,

    Lily


    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com

    Wednesday, January 8, 2020 6:22 AM