Parameter error

Question

Post reply

Parameter error

saidapurs

Hall of Fame

Points: 3477
More actions
September 10, 2012 at 12:12 am

#267377

Hi All,
I am week in write the query. Below query i am executing for upload the data to s3 cloud, while executing this query getting error like The put command required two parameter. Please help me on this.
cmd prompt:- s3 put Glee_Test C:\Backup\Test\ s3://Glee_test/
Glee_Test :- Bucket name
C:\Backup\Test\ :- Source path
s3://Glee_test/ :- Destination path
Thanks in advance...
Satish

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Nesuke SSC Enthusiast Points: 196 More actions · Answer 1

You may be better off holding the parameter values in a declared variable(s) then passing it into the command.

HowardW One Orange Chip Points: 29109 More actions · Answer 2

You seem to have a command line application called "s3" that interfaces with Amazon S3. I've no idea what this is or what the syntax is supposed to be.

What application is this and what does it say in its documentation for the syntax of the "put" command? That's how you're going to solve this, the error isn't being returned from SQL Server, it's from this command line application...

saidapurs Hall of Fame Points: 3477 More actions · Answer 3

Hi Howard,

S3 is the tool of Amazon and it is use for move the data from local desktop to S3 bucket.

PUT is command for move the data.

Thanks

Satish

HowardW One Orange Chip Points: 29109 More actions · Answer 4

saidapurs (9/10/2012)
S3 is the tool of Amazon and it is use for move the data from local desktop to S3 bucket.
PUT is command for move the data.

Right...There are many command line tools for Amazon S3. Seriously, reading the documentation should be the first step. Is it this one?

http://s3.codeplex.com/wikipage?title=put%20command&referringTitle=Documentation

If so, this is the syntax of the put command:

s3 put <bucket>[/<keyprefix>] <path> [/big[:<size>]] [/backup] [/sync] [/acl:<acl>] [/sub[:withdelete]] [/yes]

So, strip out the optional parameters (in square brackets where you need to use a switch) and you're left with:

s3 put <bucket> <path>

and what you've put:

s3 put Glee_Test C:\Backup\Test\ s3://Glee_test/

or:

s3 put <bucket> <source path> <destination path>

So, the error would make sense as the "bucket" is presumably the destination path and the syntax doesn't support what you're trying to do.

Does this work?:

s3 put Glee_Test C:\Backup\Test\