Sure:

But if I make s simple change to the folder path, there isn't a problerm.

Problem

\\phxp-sfs-003\phxmbumcacrdltr\TestZipping Folder\20130118_Care_Reissue_Export.txt

NO PROBLEM

\\phxp-sfs-003\phxmbumcacrdltr\TestZippingFolder\20130118_Care_Reissue_Export.txt

Here is all the data from the Execute Process Task on the process section

RequireFullFileNameTrue

ExecutableC:\Program...

No I do not make any changes to the variable from the foreach loop and when I review the variable in a break task is reads like this

@[User::UnZipFileName] = {"\\phxp-sfs-003\phxmbumcacrdltr\TestZipping...

I am using a foreach loop to locate a each file and passing a fully qualified path and passing it into a string variable called @[User::UnZipFileName] to the execute process...

I appreciate the suggestion, but SSIS evaluation states the CHAR is not a recognized function.

I am so glad you replied, thank you. So is the CHAR(32) used for one space or for 32 spaces?

The exact folder name is

\\phxp-sfs-003\phxmbumcacrdltr\TestZipping Folder

So would I code it...

Anybody else have an thoguths, I am still unable to zip files in a folder location where there is a space in the folder name? I would change the name...

Thanks I really appreciate your time and assistance. I will post what works when done. I have searched everywhere and have not found a solution, so thank you very much!

I tried that with high hopes but got this message:

No files were found for this operation - Nothing to do.

?\\folder\Folder\TestZipping

Folder\20130116_data_data_Export.txt.ZIP?.

Okay well i removed

"-min -m -en " + @[User::UnZipFileName] + ".ZIP " + " " + @[User::UnZipFileName]

and used this example like the post you sent and it did not like...

Sorry the code was

"\\NetworkFolder\Address\Misc\Reports"+" "+"Processing\"

Yes double quotes are used, if you are referring to " rather than '.

Is this what you mean?

Hello Aaron,

Here are some more samples of the unzipped file names, it does appear the filename are alway the same length of 23.

...

Thank you for your reply it is greatly appreciated.

I thought I would have a problem deleting the file after I moved it. Our DBAs allow business analysts to have minimal...

Hello Craig and thank you for your reply. You make a great point and I would agree. I am going to make them a part of all of my queries....

Thank you for the reply and the recommendation. It is a pretty expensive option but I am starting to think if we need to truly parse the file correctly it...