Maddave (3/13/2015)

---

Thanks all for your help. I didn't want to run the job all the time as it can be quite intensive and users could be searching historical data whilst...

Going off on a slight tangent, what about bad error messages?

I've just had this one in SSIS:

Executing the query "exec ..." failed with the following error: "Package execution failed...

Gary Varga (3/13/2015)

---

Yes!!! Commented out code. That's what source code control is for. If you need to leave a reference to old code then just leave a comment WHY it...

Superfluous comments are worse than no comments. You know the type:

--Find the average

select @avg = avg(x)

Reminds me of those people who, when doing presentations, just recite what is written on...

One simple solution is to schedule the package to run frequently and process any files it finds. If it finds no files, it completes without doing anything.

Might that work?

Nice work Stephanie. Are you involved in QA by any chance? If not, you should be:-)

You cannot 'ignore' this. You need to refine your match criteria to avoid it.

Brandie Tarvin (3/11/2015)

---

Ummm... That's a good question. Where would I look to find that information? (Someone else...

What sort of C# app is this? Windows forms, console, web etc?

Try adding a couple more statements:

switch (name) {

case "Job1": this.DTDQC.Src = Page.ResolveClientUrl(imagename);

break;

case "Job2": this.XMEDPTX.Src = Page.ResolveClientUrl(imagename);

break;

default:

MessageBox.Show("hello, how are you");

break;

...

So something like

MessageBox.Show("Here is the message");

is highlighted as an error? It should work. Could there be an error on the preceding line?

Are there any triggers on any of the target tables?

So do the replace first, then the split.

That would not help either. I would have to do one join on the update for the transactions found, a delete for transactions not found followed by an insert of...

You could break your string into its individual words, using something like Jeff Moden's splitter[/url] and then match those against your bad words table. That should run fairly quickly.