SQL Server Tools default Location
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