Yeah just gotta find out who the POC is. The thing that puzzles me is that we don't use the entire path when we use filezilla, shouldn't it be the...

Just ran it in DOS and received an error saying Host does not exist. Now I'm thinking even more that it is the missing drive letter

I'm thinking it may be that I don't have the entire directory in the script file for the source folder. Every other example I've seen online shows a complete one...

I have several files in the folder that need to be zipped into the same zip file

Added an Exe sql task with WAITFOR DELAY '00:00:02'; in the foreach loop before the exe process task calling 7 zip but still getting error

I see that the post has

winzip32 [-min] action [options] filename[.zip] file(s)

I don't have WinZip32. Can I just substitute in WinZip64?

fixed the issue using the following

UPDATE Top(1000000) s

SET [Status] = 'Ready'

FROM [dbo].[G_ASM_Submission_Staging] AS s WITH (NOLOCK)

where [Status] = 'Staged' and [Batch_Group] = @Batch_Group

There aren't any mathematical calculations but there are several Case statements. I'd post the query but its a monster

Actually I was correct in the query but I just forgot to add IsNull to columns in the Where clause:

Select Count(*)

from dbo.G_MASTER_CODING_RESULTS AS mcr WITH (NOLOCK)

where mcr.REVIEW_TYPE = 'HCR'

...

Well, that's not the exact query I'm working on. Scaled it down quite a bit. My query has 80 columns with several case statements etc that returns 1 million records....

Yeah, was trying to save time loading the CTE but guess I can't get around it

Yeah we need to use NOLOCK. Don't really need the query hint for the index. Tried without it and they were used....was just trying to make sure the new one's...

I figured out a way around it. The reason I was getting an error was, apparently, even if one of the expressions weren't supposed to be used when there wasn't...

Yeah its between the CTE's and main query. Need that value for some math

Ended up using CozyRoc's Excel Destination Plus