Parameter error

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server 2008 - General » Parameter error

Parameter error

Rate Topic

Display Mode

Topic Options

Author

Message

saidapurs

Posted Monday, September 10, 2012 12:12 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, May 13, 2013 2:46 AM
Points: 167, Visits: 413

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

Post #1356566

Nesuke

Posted Monday, September 10, 2012 4:29 AM

Forum Newbie

Group: General Forum Members
Last Login: Thursday, April 11, 2013 2:31 AM
Points: 8, Visits: 26

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

Post #1356633

HowardW

Posted Monday, September 10, 2012 5:02 AM

Ten Centuries

Group: General Forum Members
Last Login: Tuesday, April 30, 2013 5:55 AM
Points: 1,034, Visits: 7,660

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...

Post #1356654

saidapurs

Posted Monday, September 10, 2012 11:55 PM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, May 13, 2013 2:46 AM
Points: 167, Visits: 413

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

Post #1357146

HowardW

Posted Tuesday, September 11, 2012 1:57 AM

Ten Centuries

Group: General Forum Members
Last Login: Tuesday, April 30, 2013 5:55 AM
Points: 1,034, Visits: 7,660

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\

Post #1357180

« Prev Topic | Next Topic »

Permissions