Setup a proxy account using the domain windows account added to your DBA group.  Then set the job steps to run using that proxy account.

No need to change the service...

The stored procedure that is used by the maintenance task checks the file(s) to be deleted are from the instance where the job is running - and validates the files...

Without seeing everything that occurred - it would be almost impossible to determine why the process failed the first/second time.  With that said - it is possible that another tlog...

The security context is determine by the owner of the job - or the Run As for each step.  You can setup a proxy to run specific types of job...

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

This is a case where I would use C# in a script task to set variables - instead of trying to build it as an SSIS expression.  The C# code...

That is...

You could also do this:

Declare @firstOfYear date = dateadd(year, datediff(year, 0, getdate()), 0);

Select Case PeriodID
            When...

Yes I just created a sp as an example. If I keep views, I would need to put the DB1_QA   and   DB1_TEST onto a separate SQL Server.  Yes only...

Sorry - the wildcards should be '*' instead...but you can also try a few other methods:

=Lookup(IIf(Fields!RunStatus.Value.Contains("(Failed)") , "Failed", Fields!RunStatus.Value), Fields!Status.Value, Fields!Colour.Value, "StatusColour")

=Lookup(IIf(InStr(Fields!RunStatus.Value, "(Failed)") > 0, "Failed", Fields!RunStatus.Value), Fields!Status.Value, Fields!Colour.Value, "StatusColour")

=Lookup(IIf(Fields!RunStatus.Value.IndexOf("(Failed)")...

The performance is going to be based on the query performance - and that will be dependent on the indexes available and how the query is written.

I would not say...

Instead of moving the log file - why don't you add a secondary log file in the new location.  Once the migration process is completed you can then remove the...

What does that mean?

What are your expected results?

Something like this?

=Lookup(IIf(Fields!RunStatus.Value Like "%(Failed)%", "Failed", Fields!RunStatus.Value), Fields!Status.Value, Fields!Colour.Value, "StatusColour")

Great Idea! Thanks Phil. This would work if they were loading a full set of data each day, but unfortunately its an incremental load, meaning 24 hr of data...