unzip file from t sql cmd line

Question

unzip file from t sql cmd line

dallas13

SSCertifiable

Points: 7491
More actions
July 12, 2016 at 1:27 pm

#311696

Hi I am getting incorrect command line error when I type this code,
DECLARE @Result int
DECLARE @cmd varchar(200)
set @cmd = '"\\localhost\7-Zip\7z.exe" C:\test\servername_dbzip_testdb-20160712.zip c:\test\dumps'
print @cmd
EXEC @Result = xp_cmdshell @cmd

Viewing 8 posts - 1 through 7 (of 7 total)

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

GSquared SSC Guru Points: 260824 More actions · Answer 1

What error are you getting?

- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread

"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

Phil Parkin SSC Guru Points: 246960 More actions · Answer 2

Is your server really called 'localhost'? I know that works for default SQL Server instances, but I'm not sure about UNC paths.

The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin

dallas13 SSCertifiable Points: 7491 More actions · Answer 3

Here is the error message:-

NULL

Error:

Incorrect command line

NULL

dallas13 SSCertifiable Points: 7491 More actions · Answer 4

yeah when I type \\localhost in windows explorer and because I have shared 7-zip folder, I can browse this path and its my local machine where I am admin

GSquared SSC Guru Points: 260824 More actions · Answer 5

Have you tried running the command in the command-prompt directly? As opposed to through xp_cmdshell, I mean.

- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread

"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

Phil Parkin SSC Guru Points: 246960 More actions · Answer 6

You have not included 'e' (Extract). See info here.

Gus is right: make it work natively first, then plug into T-SQL.

The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin

dallas13 SSCertifiable Points: 7491 More actions · Answer 7

Thanks Phil and GsSquad it worked, When I added some switches.

set @cmd = '\\localhost\7-Zip\7z e C:\test\servername_dbzip_testdb-20160712.zip -oc:\test\dumps *.bak -y'