So it sounds like you want to adjust it to return the string minus the last character.

I would use a combination of LEFT and LEN (not 100% sure on the...

running the script from C:\ though is different than running it from c:\temp or any other folder.  If "file.bat" is using relative paths instead of absolute paths, it may be...

Depending on how you are doing the move from work table to reporting table, that could be the problem.  Is it a wipe and reload?  Is it a merge?  Is...

I generally don't install SSMS on the server.  To me it feels like extra overhead for little benefit.  I have SSMS installed on my workstation and I connect to the...

As a random guess (I can't see the code in your bat file), it is either using relative paths OR is using network shared drives.

Since SQL says it ran successfully,...

As a thought, are you using NOLOCK?

As a second thought, are you doing any transforms on the data in the Data Flow task that MAY be changing the data?

Another thought,...

I think it would help to see current output and expected output.

Looking at what you wrote, I don't see why it would add a comma in front of closing date...

That error usually means a COM object is not registered correctly.  I am not sure what COM object corresponds to that CLSID, but if you can determine that, you MAY...

I think the first step is to define user requirements.

My understanding of an "air gapped" system is that the system is on an isolated network with limited access to it...

Glad you found the answer.  Could you share it with the group?

I know I have not seen this issue before.  Generally though, I have a different habit.  I disable the...

Question 1 - As far as I am aware, three is no limit on the SSRS side, but there is a limit in how long the URL can be -...

How much free disk space do you have?  Can tempdb grow?

Also, is that 200MB the data size, the log size, or combined?  Knowing the individual values would help.

Lastly, what are...

With my experience, installing CU's or SP's via WSUS is a slow and painful process where it happens one instance at a time and generally needs a reboot between installs.

I...

This sounds like a better question for your licensing provider than a random forum post, but I can try to help here.

Best I can tell, there is no difference between...

Just to confirm - the totals when you run it unfiltered are NOT showing up, but when running it filtered, they ARE showing up?

If the above is correct, I would...