August 12, 2013 at 7:05 am
I have a folder in D:\Payslip with a set of files.
I have a table which stores the file name. Based on stored procedure inputs i need to create a zip file with the file names based on table in the same folder.
Please suggest which command can be used without using tools like winrar, 7zip, winzip
August 12, 2013 at 7:09 am
Why would you do this with a database engine?
Languages like .NET are far better suited for this.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
August 12, 2013 at 7:16 am
DOT net cannot be used as company tools use sql server technologies. Henc it has to be done using xp_cmdshell command in sqlserver.
August 12, 2013 at 7:18 am
You could probably shell out to something like WinZip, but I have to agree with Koen - don't use SQL for this. Use .NET or another language.
August 12, 2013 at 7:21 am
vikramchander90 (8/12/2013)
DOT net cannot be used as company tools use sql server technologies. Henc it has to be done using xp_cmdshell command in sqlserver.
And what exactly would you be calling with xp_cmdshell?
Exactly, either a 3rd party tool (there are free ones available), or a vbs script file (not really .NET, but who's paying attention?).
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
August 12, 2013 at 7:23 am
Zipping using basic command available in windows.
August 12, 2013 at 7:27 am
vikramchander90 (8/12/2013)
Zipping using basic command available in windows.
You need vbs script for that:
http://superuser.com/questions/201371/create-zip-folder-from-the-command-line-windows
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply