SQL Server Tools default Location

Article
06/02/2017

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