Execute Process Task executing .bat file

Question

Execute Process Task executing .bat file

Usha-375170

SSC-Addicted

Points: 413
More actions
November 13, 2006 at 1:03 am

#67954

Hi,

I have DTS package which creates text file.In the next step I have included execute process task to zip the text files.The content of bat file being:

"C:\Program Files\Winzip\Winzip32" -min -a e:\x.zip e:\*.txt.

When I execute the package using execute button it works fine.but when I call the dts package using dtsrun command in datawarehouse procedure,It goes on executing into an infinite loop without giving any error message.
Please help me regarding the same
Regards
Usha

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

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

Ian Yates SSCoach Points: 19738 More actions · Answer 1

Perhaps winzip is displaying a hidden window?

I'm not familiar with winzip's command line abilities (it may well be suitable) but you could go for a dedicated command-line archiving app such as RAR.

If you have your batch file simply perform a copy command, for example, does it freeze? If so, then winzip's not the problem. If not, then the winzip command itself is probably the cause and changing compression progs might help.

Usha-375170 SSC-Addicted Points: 413 More actions · Answer 2

Usha-375170

SSC-Addicted

Points: 413

November 13, 2006 at 2:04 pm

#671444

Thanks.Will try and let you know the result.

Ron Aughenbaugh SSC Eights! Points: 975 More actions · Answer 3

I do know that with Winzip9 the command line functionallity is only available with a paid license and can be downloaded from winzips site. Attempting to run without the license will display a message on the commandline which pauses the process and will not proceed until you hit some key on the keyboard.

Usha-375170 SSC-Addicted Points: 413 More actions · Answer 4

Hi

I have got the license for winzip tool.Now am facing another issue.

When I execute the following command:

exec master.. xp_cmdshell 'dtsrun /S Server name/N packagename /E'

I am getting following.

DTSRun: Cannot create COM Server to load and execute DTS Package. Error -2147221008 (800401F0): CoInitialize has not been called.

only I fix this issue I ll b able to test the winzip.

Please help me in above.Thanks in advance

Usha

Usha-375170 SSC-Addicted Points: 413 More actions · Answer 5

Hi

I was able to fix the previous issue.I registered dll for dts again.Now regarding Winzip,I have winzip command line utility in Execute Process task.If I run it using Execute button it works fine.If I run the dtsrun command for executing the package that zips text files at command prompt it works fine.

but am not able to execute if I execute through jobs in SQLSERVER agent or if I use xp_cmdshell to execute the package.It get into infinite loop.

I have also enabled the execute main pakage thread properly in workflow property.

Any suggestion wld b helpful

Regards

Usha

Ian Yates SSCoach Points: 19738 More actions · Answer 6

I'm not 100% familiar with DTS but I believe that if you run using dtsrun then your package will execute using your permissions. When run from SQLAGENT it will use SQLAGENT's user account. Perhaps you have a permission issue, particularly if you are accessing any network resources. Is E: a network drive? If so, you'll need to add a NET USE statement to your batch file because network drive mappings are user specific (and may not hang around between sessions, depending on your settings).