Excellent, EXCELLENT!!!

JamesNT

Will SQL Server 2008 include Visual Studio 2008 or will we have to learn yet another tool for authoring SSIS and SSRS packages?

JamesNT

pduplessis,

Thank you for the compliment. Yes, that did solve my problem. I appreciate the follow-up!

Also, I find your story intriquing as well. Sometimes you just have to...

My apologies, everyone.

The connection string should start with Data Source, not Datasource.

James

Thanks Lynn, that worked great!

What we have that parses correctly is:

replace(replace(replace(Phone, "-", ""), ")", ""), "(", "")

So now I have one derived transform instead of 3.

Thanks again!

JamesNT

SSIS-ey?

LOL

We are only talking about 10,000 rows of patients and yes, it does work. I was thinking there might be a more elegant way, but it appears according to...

Mr. Earl,

First, thank you for your response. Apologies for not responding sooner but things have been hectic around here. I'm trying to get ready for a conference/vacation starting...