See attached error message, we managed to get around the issue by copying the sqlcmd.exe, sqlcmd.rll and batchparser.dll from the server where SQL is into the folder with the bat...

Don't remember it being a text file but thanks Andrey, will take a look. I've just found an old Bat file from 2015 that was still being used up until...

We have that for other processes that are run by jobs however I need to check if this particular user has access to our ERP. Thanks for the feedback.

Thanks for coming back to me on this, its a specific SQL Agent job that needs to be run once a file comes in from a 3rd party. That file...

Sorry forgot to say, it does appear that we only get the duplicates when we see the Null Value Warning, we have five of these stored procedures that run one...

Thanks for this, I have removed the SUM's. The data itself is pretty straight forward and we have had issue with this before that have been rectified. The odd thing...

Hi John,

The job is scheduled to run at the same time every evening at 21:00.

Here's the code, thank you.

Declare @Costtype varchar(50)
Declare @ACCTID...

Hi GilaMonster,

Thanks for the response, it actually works in our favour I think as the procedure sends an email at the end so we can see where the...

Thanks tindog, i've had a quick look for xp_SMTP_sendmail but its looking increasingly likely that this could be the way to go.

The jobs are mainly just sending the results of...

Found the issue, the Code.DateParameter part of the formula for the parameter was looking at a Report Property which had the old name in it, once I updated that the...

Sorted, it was the Parallelism setting on the report server which was set differently to the live server

I've opened the file in Ultra Edit and it is definitely ANSI

When we added a data viewer the data is correct, the issue seems to occur when the data is added to the csv file.

Unfortunately we still had the same issue this morning

I have changed the .dtsx file to the second option and re-deployed the package, unfortunately I cannot run the export during office hours as it may lock up the system...