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, 11 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...

Another option would be to use 2 sources in the data flow - add a merge or merge join and output the results to the destination.  Each input source to...

  Alter Function dbo.WorkingMonthDates (
        @inputDate date)
Returns Table With schemabinding 
     As 
 Return 

...