Thanks for the reply Ant, I was looking for the process and you seem to have hinted at it.

Unfortunately we don't have a .bak from before the target...

Bugger.

OK, so it appears I have two options. Either:

Go back...

So based on that picture and to get it to 8am on the 8/4/2022

Restore the 11:00pm full with no recovery Restore the 6am diff with no recovery Restore the...

Let me rephrase what I'm after. I've borrowed the screenshot from a different example but the same principle applies.

I have a database in its current state and the backups below....

This is not possible. You will need a...

Thanks for the reply Ant, I was looking for the process and you seem to have hinted at it.

Unfortunately we don't have a .bak from before the target to go...

Next step on the debug root now we've sorted the "is it plugged in" equivalent.

Can you swap the exec for print so that you can see exactly what...

That's straightforward.

The number of columns in your DataTable don't match what's in your final select statement. Using SELECT * will always leave you at risk.

Next step on the debug root now we've sorted the "is it plugged in" equivalent.

Can you swap the exec for print so that you can see exactly what is executed?

That...

I'd check your variables.  No sign of @FILEPATH being declared or populated anywhere in that.

What does the execute statement of the stored procedure that you are issuing look like?

The Data Warehouse Toolkit by Ralph Kimball

I first acquired...

A data warehouse should be built to answer business questions in an accurate and timely manner.

If they are driving their campaigns from the data warehouse, i.e. using it for something...

This topic might be of use: https://www.sqlservercentral.com/forums/topic/exception-has-been-thrown-by-the-target-of-an-invocation-2

Who do you run it as?

How are you executing the package?

Have you tried running it from a SQL agent job?