I think I understand why the consultants you found were costing $200/hour... that is a high list of demands for the consultant.  I think if you want someone who is...

My opinion - it is tricky to find good ones, but not impossible.  Find some reputable people in the SQL World and ask them like you did on this forum.

As...

your CASE statement needs an END on it before the AS.

That should fix it for you!

To add to Grant's post, Idera and Quest both have good monitoring tools too.

But if all you care about is uptime, how frequently are you needing to check that for...

Is your linked server is pointing to the same TNSnames file that you modified (possibly a copy of the file on the SQL Server itself or maybe on a network...

I expect you could change your function so it returns something rather than nothing when the PartNumber is a value like VJ0805AIR5CXAMT.

Failing that, UNION or a join should work to...

Sounds like the SQL agent for some reason isn't able to see the files then.

As a thought, what if you remove the filter and run the powershell of just getting...

is the path to the DataDomain repository a network share (such as a Z:\ drive)?  if so, try using the fully qualified domain name.

Failing that, comment out the last bit...

I'm confused... in your first reply, you said there was no SSIS package and now you are saying there are SSIS packages?

While I agree that hiring a lot of contractors for a complicated project produces a complicated result; it does really depends on the contractors.  If you hire web developers to...

As Eirikur Eiriksson said, without data, it is hard for us to help you.

But lets assume that all of your columns are in a format that meets your sample data. ...

I feel the pain... My headset (bluetooth) sounds really nice... for the audio output... Bass is  a tad high, but I have tools to tweak that.  So things sound great...

Going with the assumption that this needs to be an application job, I highly doubt a web server is the right approach for this type of work.  Even a C#...

That is an easy fix - you need to change the JOIN condition in the recursive CTE to include a longer FileID.  Your old one was 3 digits, your new...

Does my sample code not handle depths of 4?  I just tried it with a depth of 4 and it worked fine.

Do you have some sample data that is not...