Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
SQL Server Tools default Location
SQL Server工具預設位置
| Tools | SQL Server versions | Location |
| sqlcmd.exe, bcp.exe | SQL 2008 R2 | C:\Program Files\Microsoft SQL Server\100\Tools\Binn\ |
| SQL 2012 | C:\Program Files\Microsoft SQL Server\110\Tools\Binn\ | |
| SQL 2014 | C:\Program Files\Microsoft SQL Server\Client SDK\ODBC\110\Tools\Binn\ | |
| SQL 2016 | C:\Program Files\Microsoft SQL Server\Client SDK\ODBC\110\Tools\Binn\ | |
| Integration Services componentdtexec.exe | SQL 2008 R2 | C:\Program Files\Microsoft SQL Server\100\ DTS\Binn\C:\Program Files(x86)\Microsoft SQL Server\100\DTS\Binn\ |
| SQL 2012 | C:\Program Files\Microsoft SQL Server\110\ DTS\Binn\C:\Program Files(x86)\Microsoft SQL Server\110\DTS\Binn\ |
Reference:
File Locations for Default and Named Instances of SQL Server
/en-us/sql/sql-server/install/file-locations-for-default-and-named-instances-of-sql-server
dtexec Utility
/en-us/sql/integration-services/packages/dtexec-utility