Post reply

SSIS 2017 dtsexec.exe

  • March 1, 2018 at 2:57 pm

    #329528

    I did an in place upgrade of SQL server 2017 from SQL server 2014

    I also removed the SQL 2014 from the control panel-programs.
    But I found the SSIS 2014 is not uninstalled,

    I have some command line script written to call dtexec.exe like below:
    dtexec /FILE "D:\_SSISPACKAGES\mypackage.dtsx" /CHECKPOINTING OFF  /REPORTING EWCDI
    exit /b %errorlevel%
    Then I found the version it used to run is version 12.0 that is SQL 2014 our old SSIS.

    How can I make it to use the newer version of 2017?

    Thanks

  • March 2, 2018 at 3:09 pm

    #1981829

    sqlfriends - Thursday, March 1, 2018 2:57 PM

    I did an in place upgrade of SQL server 2017 from SQL server 2014

    I also removed the SQL 2014 from the control panel-programs.
    But I found the SSIS 2014 is not uninstalled,

    I have some command line script written to call dtexec.exe like below:
    dtexec /FILE "D:\_SSISPACKAGES\mypackage.dtsx" /CHECKPOINTING OFF  /REPORTING EWCDI
    exit /b %errorlevel%
    Then I found the version it used to run is version 12.0 that is SQL 2014 our old SSIS.

    How can I make it to use the newer version of 2017?

    Thanks

    Use the fully qualified path to dtexec - something like: C:\Program Files\Microsoft SQL Server\140\DTS\Binn\dtexec.exe

    Sue

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply