Please will you share what you did? It will help anyone who's having a similar problem to yours.

On page 99 (https://drive.google.com/open?id=0ByFnKe4djAO-d29ZTUJrbExhbzQ)...

Your screenshot doesn't show the whole value of the variable. Does it include the name of the csv file? Have you tried it with and without? Please...

Run the job every five minutes, say, and have it check whether the file exists. If it does, proceed to the part of the job that does the processing.

John

Sanjay

So you did. Please scrub "log files" from my response.

Can you please...

Sanjay

You may be able to claw back some space by deleting unneeded files from D, or shrinking any data or log files that you know are too large and will...

If you made schema1 the default schema for user1, that'll only work for user1, not for you as well, unless your own default schema also happens to be schema1.

John

Did you remove it from the SELECT list and the GROUP BY clause?

John

Edit - corrected italics tags

Can you not just dispense with the Year column? What do you need it to represent?

John

Definitely don't have it running, then.

John

I wouldn't run it as required - I would either use it or not use it. It only works for named instance, so if you only have a default...

It's because for those particular values of date, you have two separate values of Year. Presumably this is caused by arrival date and departure date being in different years.

John

Edvard

Yes. Can you imagine the confusion if it were any other way? You wouldn't know whether you were getting old values or new values!

John

Edvard

Yes, that's how it works. Try declaring @starttime and @endtime variables and setting them to the new values. You can then use them in the update query instead...

I don't know. There's a ConnectionString column in the DataSource table, but it's not in plain text. Like I said, I don't recommend hacking the tables, and I...

What sort of data source do your reports use - embedded or shared? If you use a shared data source then you only need to change it in one...