ODBC guide

Download a file from a shared drive

Downloads a file from a shared drive to a local path. Supply DriveId, DriveType='drive', the file ID, and the destination path.

SELECT * FROM download_file
WITH(
	DriveType='drive',
	DriveId='0AFWIggplk2z6Uk9PVA',
	Id='1hk7odj2Y2--yxN9DY0zW88hSnxqiyHq0',
	ResponseDataFile='c:\temp\dump.zip'
)