People are probably scratching their heads at that code. Maybe you could explain what it's trying to do.

The first thing is that a varchar(10) is declared but a numeric...

Your questions:

Your assumptions may or may not be right. Adding or altering the indexes on your base tables may improve performance of the report but it may also harm...

Hi Chuck, I see you have no responses so I thought I'd throw some ideas in the pot.

There may be tweaks in Exchange to process the emails faster but...

TFS has check-in alerts (for specific folders) so you could look into that too. I'm not sure whether Redgate's version control does it as well.

I don't really have an answer for you but BOL says

DISABLE

Prevents lock escalation in most cases. Table-level locks are not completely disallowed. For example, when you are scanning a...

1. You could add a separate task to check whether the file exists, or use the OnTaskFailed event, instead of OnError, which only fires once.

Question 2. File System Task....

If you want help, you'll have to show the rest of the code i.e. how you declare and populate the variables.

To debug this, you should put the whole command you...

You're going to have to do a left join from the table to itself. The LHS resultset will have 'SourceSystem = 3' and it will join to records with...

It's possible that we have differences in our data files, probably hidden characters. You'll have to experiment, maybe look at CR LF characters

I apologise. I had been editing the source file to remove commas from within the fields, e.g. some of the directors have names separated by commas. I...

Did you use the 'encode' or 'convert' choice in notepad++?

I used 'convert to ucs2 be bom' and saved the file, then a simple bulk insert as.

BULK INSERT dbo.rawData

FROM ...

You'll have to debug the sp you call.

The version of the sp I found takes a @database parameter which is VARCHAR(128) and it defaults to NULL ....

I'll help but you have to show some effort.

Did you follow my suggestions in the last post? If you just need the data on a one-off basis, then that...

The changes are

1) They've added a namespace declaration

2) Attributes and elements have been altered a bit

To solve 2, remove the namespace in the xml file (just for testing) and...

Make sure the xml is well-formed. I think you should look at your url statements first. Also look at the ampersand in one of the urls.

You might also...