Uploads objects in a single operation. Use the SimpleUploadLimit connection property to adjust the threshold in bytes in order to perform a multipart upload.
The Driver Uses #TEMP tables as fields for aggregate information entered
You must include in your query :
INSERT INTO ObjectInformationAggregate#TEMP(LocalFilePath) VALUES ('C:/amazons3/test/testfile.txt')
Then you execute the procedure by specifying the value of ObjectInformationAggregate with the name of #TEMP table used ObjectInformationAggregate#TEMP.
Exec UploadObject ObjectInformationAggregate = 'ObjectInformationAggregate#TEMP'
|Bucket||String||True||Bucket name where the object will be uploaded.|
|FolderPath||String||False||The path to the folder that will receive the data of the object.|
|LocalFilePath||String||False||The path to the file that will be uploaded in the bucket. If this is a path to a folder, then all the files in the folder will be uploaded in the bucket.|
|ObjectInformationAggregate||String||False||An aggregate representing the object information. Can be in the form of XML, JSON or a #TEMP table.|
Result Set Columns
|Object||String||Object name for the object that is uploaded.|
|Success||String||Indicator if the stored procedure was successful or not.|