Here is the code I use for the archive task:

            bool fireAgain = true;

  ...

I searched the following: sql server proxy account ssis

Here are the top 3 items...

Are you sure the problem is in the extract portion - and not somewhere else?  You stated you are joining 2 tables to get the results - each table has...

Posted to wrong thread - removed

• This reply was modified 4 years, 4 months ago by Jeffrey Williams.

The method @JeffModen proposed is much faster to calculate the fiscal year.  When combined with filtering in the where clause - it would be better than your case expression.

Since you...

How did you create the report?  Did you use the wizard - and if so, what options did you select?

Based on the picture, it looks like you used the wizard...

You still need to view the context of the errors to see if there is more information.  But based on your description - the issue is most likely a permissions...

I wasn't responding with that as the issue - just responding to Thom on why use a script task.  I would not expect anything in the script task to affect...

In the code you posted - it would be much better to use @JeffModen's calculation for FY.  However - because that value is calculated and he calculation is on columns...

If you move a file in Windows - it retains the properties and...

I don't disagree with this comment, but... There is a precedence constraint between this task and the unzip task. Why would the Execute Process task mark "successful"...

My best guess is that you are getting these errors because the cluster cannot determine quorum.  On a 2 node cluster - you need 3 votes, which would be handled...

It will depend on your Windows OS on the existing cluster - you can only go from 2012 to 2016, or 2016 to 2019 - but not from 2012 to...

While I don't see it as causing any serious issues, I'll state again that I find that applications that require snapshot isolation to get performance to be annoying at...

Yes - with a computed column added...