Zipping a txt file

From: Varsha Karnik <bounce-varshakarnik2805@tessituranetwork.com>
Sent: 12/5/2010 10:28:15 PM

From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Ben Gu
Sent: Monday, 6 December 2010 3:12 PM
To: Varsha Karnik
Subject: RE: [Tessitura Technical Forum] Zipping a txt file

I've create batch file:

@Echo off

"\\keenm\c$\WinZip\WZZIP.exe" "\\Dell\Tessitura\Source\sso_pacingdata.zip" "\\Dell\Tessitura\Source\sso_pacingdata.txt"

---------------

Now I run

master..xp_cmdshell 'Text_Zip_Cmd.Bat'

It runs perfectly from command prompt but in SQL i get following error.

ERROR(\\keenm\c$\WinZip\WZZIP.EXE,103): WinZip is not installed.

You must install WinZip in order to use the WinZip Command Line Support Add-On

NULL

Earlier I thought it was Winzip license issue but after fixing it and also installing command line add-on I'm getting this error.

When I run xp_cmdshell 'dir \\keenm\c$\winzip' I can see all files..

similarly when I run xp_cmdshell 'dir \\dell\tessitura\source' I can see all files..

that means I'm able to access all files, but I can't understand what’s missing when it comes to SQL Server.

Any help will be appreciated..

Thanks

Hi Varsha,

good day.

the easiest way to fix the permission issue is using  'Execute as'.

in the stored procedure, you can do something like this:

ALTER      PROCEDURE [dbo].[AP_BCP_FILE]
    (
     @file_name     varchar(255),
     @format_file     varchar(255),
     @table_name     varchar(255),
     @db_login     varchar(255),
     @db_password     varchar(255) = NULL,
     @bcp_in_out    varchar(10),
     @err_file    varchar(255) = null,
     @hint        varchar(255) = NULL,
     @cDebug    char(1) = 'N',
     @include_output char(1) = 'Y'        -- added 3/12/2007 by lwl
    )
WITH EXECUTE AS 'dbo' -----you can replace dbo to 'mynetwork\admin'
AS

you can put network admin account in sql account, then you can use that account do some special things when you need access network resource.

have fun

Ben

Please consider the environment before printing this email.

    =====This message is intended for the addressee(s) named and may contain confidential information.

    If you are not the intended recipient, please delete it and notify the sender.

    Views expressed in this email are those of the individual sender and are not necessarily the views of the Sydney Opera House Trust=====

This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!