Spot on!!!!

Thanks.

Thanks for your help. After discussions with some of my microsoft guru contacts, they suggested I simply create a console or winforms app to leverage the membership, roles and...

I was able to get the Table Profile stuff working no problem. I'm currently trying to figure out how to call the System.Web.Security.Membership API from w/in a custom script...

beezell (6/19/2009)

---

Here's one way to do this. This is using a CTE (assuming you're using 2005 or higher). If not, it is easy enough to wrap up as...

Holy Crap Dude, that's awsome. Works perfectly!

I really appreciate it. 🙂

GSquared (5/14/2009)

---

That won't work. You're selecting a distinct value in an inline sub-query, that means that one row is distinct when compared to nothing at all. That won't...

Ok, so I execute the following on the table:

update dbo.masterenroll

SET SSN = (

select distinct right('000' + cast(abs(checksum(newid()))%1000 as varchar(3)), 3) +

right('00' + cast(abs(checksum(newid()))%100 as varchar(2)), 2) +

right('0000' + cast(abs(checksum(newid()))%10000 as...

Hi, thanks for your response. Unfortunetly, I don't have an ID. Sux I know.

Thanks for your response. I tried your suggestion and got a ton of duplicates.

Hmmmm.

GSquared (4/28/2009)

---

Personally, I don't think I've ever used SSIS to move data from one SQL database to another, on the same server. I use T-SQL scripts/procs for that. ...

Interesting point. I'm going to stew on that a bit.

Thanks!

stevefromOZ (4/28/2009)

---

Just out of interest, are you running this package (packages) in Visual Studio (ie debug) or pushing them to the SSIS service and executing them via say SSMS or...

Jetro (4/28/2009)

---

Hi,

Why do you have one package for each of the source tables? Maybe it helps to create one package with one dataflow task for each of the source tables...

Hi, thanks for your response.

"I'm not sure I have the complete picture. Are the sources of the web databases data all SQL Server databases or some other kind of...