Hi Phil,

I did that, I have identified the tables running the longest and am isolating those for testing :).

There are some tables that have dependencies on...

Yep, done the Telnet test that's fine and the port is accessible.

I do have PowerShell as the command and then I also added the path to the PowerShell.exe...

One of these days, I will get it right.

Thanks Gail and Phil, I should have added dates apologies.

So, if I was running the report on the...

Thanks both, the source is using that connection as advised by the company but I will take a look at that.

JasonClark, I have given access to the appdata\local\temp...

Thank you, I think I got too embroiled in GRANT rather than DENY.

I tested it (of course) and works like a charm. Thank you.

Jeff, I can see what you mean now. We do have an offsite backup solution that happens too. I am looking at some other possible options (cloud backups for example)....

Jeff Moden (10/27/2016)

---

Ed Wagner (10/27/2016)

---

Jeff Moden (10/26/2016)

---

Kazmerelda (10/25/2016)

---

My email to them has said I am not prepared to take off backups, and my worry is we won't have that space...

Eric M Russell (10/25/2016)

---

Kazmerelda (10/25/2016)

---

Now they want to offer me RAID5 instead of RAID10 *weep*.

Eric, I think you could be right here I am a belt and braces person and...

Now they want to offer me RAID5 instead of RAID10 *weep*.

Eric, I think you could be right here I am a belt and braces person and I don't overspec but...

Ed, completely agree. My email to them has said I am not prepared to take off backups, and my worry is we won't have that space put in for them....

I am using the expression to pass the dates via a variable to the query variable so at that point can't transform, unless I am missing something (finally using my...

Spiff, normally I would use that but I am pulling data from Oracle which is a whole world all by itself it seems and does not like that at all....