I have to wonder why you have a database by client. This screams poor design on so many levels.

@john-2, the only reason I can imagine that the OP...

From a SQL perspective you're going to need tables of names, and then logic to define how the phone number is generated using the state as well. SQL doesn't know...

Ok, well best option would be to treat your XML like a dataset. It has repetitive groups, which makes this easier.

So, with some similar XML I could...

What have you tried so far to limit your result set?

I might be being daft, but is this not as simple as:
REPLACE(REPLACE('Hello all!   How Are you ?:', ' ',''),':','')

You should be able to do this one yourself, considering how long you've been here 🙂

https://www.google.co.uk/search?q=REPLACE+%28Transact-SQL%29&ie=utf-8&oe=utf-8&client=firefox-b&gfe_rd=cr&ei=kIn3WI6ZL6n38AfxloHoCg#safe=strict&q=REPLACE+T-SQL

"Without worrying about types". That doesn't terrify me in the slightest...

I'm just going to run some quick SQL.
Update Ledger
Set Debt = 'Pancakes';
Ahhh, I feel better...

Personally, I would suggest moving to the SSISDB deployment method. It's a lot more secure (no storing passwords in plain text in a file directory) and easier to manage.

Can I assume that you're editing the dtsx file directly on the file directory (probably located on your SQL server), and you're not using the SSISDB deployment method? (If so,...

Duplicate of https://www.sqlservercentral.com/Forums/1871557/SSIS-Transaction-Error

Please keep your question to one topic. 🙂

This will be hard without DDL and sample data, and especially a query plan. One thing I have noticed, however, is your joins are referencing an alias opp. You don't...