What do you want the batch script to do?

Well done for solving it. I stopped using Maintenance Plans  long time ago; it's relatively simple to 'roll your own' or use something like Ola Hallengren's maintenance scripts.

Regards

First off; what do the jobs do? Do they execute T-SQL queries, stored procedures, SSIS packages, PowerShell scripts or something else?
Regards
Lempster

If...

Wow, it took you a long time to test that! 😉

Regards

Lempster

There are a number of courses on the Microsoft Virtual Academy concerning PowerView, PowerPivot, PowerQuery and PowerBI in general.

Regards

Lempster

It's what is known as Technical Debt isn't it? Rightly or wrongly (and I would suggest wrongly) it usually comes down to a question of money, i.e. how much is...

Restarting the SSAS service would do the trick! 🙂

Regards

Lemspter

Ah, got you (I think). So the SSIS package is not failing, but you have another job step that kicks off before all the inserted rows have been committed. In...

How much data (how many rows) are being inserted? I assume this is into an OLEDB Destination so do you have FastLoad enabled? On the Data Flow Task, how many...

Thanks Steve, appreciate that. It's going to be a tough fight, but again, that has some relevance with careers: sometimes you have to battle through rather than jumping ship.

Steve, you are completely right when you say "life is short". This has just been brought home to me in a very personal way as I have just been diagnosed...

Are you using server names or IP addresses?

Regards

Lempster

Are you sure that your OLE DB Source in Step 2 is using the right Connection Manager? The error message seems very clear.

What have you got set in your OLEDB source?

Regards

Lempster