No error was attached.

Are you talking about an error displaying a specific report (ie, a data source issue) or a problem accessing the report server URL?

If a table does not have DateCreated, how would 'the system' know which of its rows to select?

Have you tried checking for build warnings in SSDT?

Also, I think that 'SQL Death by a Thousand Cuts' would be a great article in its own right.

Trying to convince application developers that it's worth spending the time to...

My apologies... there's a missing word as follows....

"Each test will have the following nearly sections:" should have been "Each test will have the following nearly identical sections:"

And I left...

I just created a database containing the following:

• schemas tst and tst2
• table tst.Test1
• proc tst.SomeProc, which selects from tst2.Test1

Clearly, tst2.Test1 does not exist and this results (by default) in...

Yuck!

If you can't change that sync stuff, here is one idea.

Create a table called FileNamesProcessed (or whatever) and write the 'current' file name to that at the end of a...

Best practice is to archive unzipped files after processing them. Just move them to an Archive folder. That way, you know that anything in your updates folder has not yet...

--deleted

• This reply was modified 3 years, 5 months ago by Phil Parkin.

OK, you made it sound like this was something which used...

According to the MS documentation, error 3737 is "Could not delete file '%ls'. See the SQL Server error log for more information."

What error message are you seeing?

I will put this rather more forcefully than Steve Collins.

If the following code gives you a varchar/numeric conversion error, there is no doubt at all that the datatypes of the...

• This reply was modified 3 years, 5 months ago by Phil Parkin.

If you remove the existing data from the Excel file, does the new data get written to the file?

What happens when you run this? Does the existing data in Excel get overwritten, or does the Excel file remain unchanged?

Good tip....