Running wzzip.exe in an Execute Process Task

Question

Running wzzip.exe in an Execute Process Task

imani_technology

SSCrazy Eights

Points: 8200
More actions
May 26, 2010 at 7:25 pm

#143351

I have an Execute Process Task within a Foreach Loop Container. The container has a Foreach ADO Enumerator that contains the output file list. In the Execute Process Task in the container, I want to essentially run the following:
wzzip.exe E:\Test_Output_Files\ABC\123\C2A255IN.zip E:\Test_Output_Files\ABC\123\C2A255IN.csv
Should the zipped file and original file names be part of the Arguments section? If not, where do they go? And where might I put the variable that represents the current item from the ADO Enumerator value?

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

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

Elliott Whitlow SSC Guru Points: 102402 More actions · Answer 1

For the command line you might reference:

http://www.google.com/url?sa=t&source=web&ct=res&cd=1&ved=0CBIQFjAA&url=http%3A%2F%2Fwww.lexjansen.com%2Fphuse%2F2006%2Fcc%2Fcc01.pdf&rct=j&q=wzzip+command+line+parameters&ei=JfD9S-L2KJWyNtjsmNEN&usg=AFQjCNEZWxafxZB825KFgpo-UZg25qLNPg&sig2=cOvz9cZ_Kj5Y-ifCYmtkNg

Within the F-E-L I would probably add a script task to actually do the calling. I don't like the Execute Process component very much. Within that script component I would build out the whole command line and then call it.

CEWII

imani_technology SSCrazy Eights Points: 8200 More actions · Answer 2

What is a good way to learn about the SSIS 2005 Script Task and scripting in general?

Ed Zann SSCrazy Eights Points: 8694 More actions · Answer 3

imani_technology (5/27/2010)
What is a good way to learn about the SSIS 2005 Script Task and scripting in general?

In a broader sense, it uses VB.NET, so becoming familiar with the .NET framework and VB syntax is necessary. I have found the Wrox book "Professional SQL Server 2005 Integration Services" by Brian Knight, et al to be very useful, along with BOL and forums like this one.

Elliott Whitlow SSC Guru Points: 102402 More actions · Answer 4

I would tend to agree. learning at least a little vb.net or c# is required, and most of that will be usuable in the Script Task.

CEWII

imani_technology SSCrazy Eights Points: 8200 More actions · Answer 5

Good advice! I have "Professional SQL Server 2005 Integration Services" and hope to look into some VB.Net books.