My biggest issue was that I assumed there wasn't more than one answer. I've gotten spoiled by the questions hinting that there is more than one answer.

To be honest,...

Congratulations!

@SQLArnold-

I haven't forgotten about this, I just was wrapped up in "other" work tasks...

So at first, I was totally perplexed on the command line not testing correctly and then I...

Yes it does...

I believe I have found your problem: In cmd line operations anytime a folder/file name contains spaces you have to wrap the entire item in "s.

Example: -min...

Ok, so its not in the variable creation...

How is the archiving happening (aka running WinZip)? My guess is that it is using the "Execute Process Task".

Can you...

My reason for the question is to see if you are verifying if you have stripped out any line feeds or carriage returns.

An example would be: the variable would...

What type of component/operation are you using to generate the variable? Or a better way of stating it might be how is the variable's value established?

No the CHAR(32) is for a single space.

Oops, I should have put an example:

"\\\\phxp-sfs-003\\phxmbumcacrdltr\\TestZipping" + CHAR(32)+ "Folder"

I know this is from left field (and I am not the foremost expert at SSIS) but have you tried the "CHAR" code for a space?

Something like: "\\NetworkLocation\TopFolder\SubFolder" + CHAR(32)...

Something to wake me up (outside the morning cup of joe).

Thanks!

I wanted to say thank you to Hugo for the in-depth explanation.

You could try something along the lines of:

ALTER TABLE XXX

ALTER COLUMN ID INT IDENTITY(1,1)

That would modify your Id column to being an identity column with a seed value...

When I first saw this question, I hadn't used the CONCAT function so I read up on it. I should have gotten the question right based off of that...

Note to self: do not try to answer SQL questions (no matter how simple) before 1st cup of coffee is consumed. In hindsight, I actually had the right answer...

Even reading up on Normalisation (or is it Normalization?), I still ended up guessing but it did get me to re-assess what I think of 1NF to 4NF.

Thanks!