radb4u (8/3/2011)

---

Thank you for the reply. I have the following code:

Row.vchImportCustomerPhoneNumber = nonumbers.Replace(phone, String.Empty)

Error says 'disallow implicit conversion of string to integer'.

So, I am trying to change the data...

radb4u (8/3/2011)

---

Hi,

I have written a script to format the phone number (to exclude special charecters). It was working fine. But, in between testing it started not working. It i sgiving...

I agree with this - it seems...

Ninja's_RGR'us (8/1/2011)

---

I'd still like a bol refference on this one. The optimizer is a tricky beast.

Anyone has a link to says that the set statement is ALWAYS eveluated /...

I know you've been around here for a very long time and I hate to suggest that you are wrong, but how does...

You can't do that - all of your field references will be to the situation as it was 'before update'.

So you need to write things out in full rather than...

Not sure I understand.

Use SELECT instead of PRINT?

What do you mean by 'not working'? Wrong result, or error? If error, please post the error.

Have you considered doing this in T-SQL as part of your select?

TTboy (7/29/2011)

---

This seems like an easy query, yet all my attempts have failed to find the answer.

Mainly I have 2 tables: TableA and TableB.

A record in TableA can have...

Edward-445599 (7/28/2011)

---

steveb. (7/28/2011)

---

There are a few ways of doing this,

one way is to write an update or delete statement in the ole destination and use this in...

steveb. (7/28/2011)

---

There are a few ways of doing this,

one way is to write an update or delete statement in the ole destination and use this in the...

You can use precedence constraints to control which logical path an SSIS package follows. So...

Can you just scan the results of the queries by eye to determine which is behaving unexpectedly?

Once you know which query is returning the wrong results, it will be easier...

Yes - or maybe a better editor like Notepad++. Even better, MS Access.

I'll state my position on this, and I know I am not alone.

If you need to store and analyse hundreds of thousands of data rows, use a database.

If you want...