Another way of doing this is to use a For Each Loop Container. Set the enumerator to Foreach File, Folder and Files as appropriate.

If the file exists, the container...

We had a similar problem with our VM when it was upsized. The infrastructure guys said that it was "just a config change" but afterwards performance was dreadful. ...

Generally the account had DBO rights in each DB. Where the SSIS package needs to access data on a remote server or sFTP we would use login details stored...

Did you consider sequence tables? I've not used them myself but would they have done what you wanted?

https://msdn.microsoft.com/en-us/library/ff878091.aspx

Jez

As Lowell said, one service account to run all SQL Agent jobs whether than is an SSIS package or stored procedures for batch process.

Jez

Personally, I think this is overkill. Usually I have a single service account to run all SQL Agent jobs and ensure that job has appropriate permissions.

If you are doing...

Are you using a UNC path or a local drive? If it is a local drive it might be that the drive/folder exists on Server A but does not...

Many of the generic triggers that I have seen, including Pop Rivett's, create an SQL statement for each column in the table so with a wide table of say 100...

Have you thought about using Broker Services?

Jez

Why do you want to do SELECT/INSERT/DELETE via a job? What is wrong with a series of stored procedures?

Jez

Output the new facts to a working table. Then use T-SQL to insert the new records and update the old ones.

Jez

Strictly speaking I think this should reside in the data layer as it is an attribute of each fact.

IMHO, the KPI would be more along the lines of "What proportion...

One way to do this is to create a variable with an expression which includes the value that you want. You can then use the variable as SQLSourceType in...

The OP already has a SSIS package that loads 140+ files sequentially.

I doubt that there are 140+ separate tasks I guess that this has already been solved.

Jez

Probably the best solution would be to put all 140+ file names into a queue table and then have 4 separate For Each Loops taking one record at a time...