It's just a diddy size, 1200 rows, nothing that'll put SQL in danger of breaking a sweat.

😀

I'll look into the T-SQL of it but this is already a good education...

Thanks mate, that looks like a good starting plan. Would T-SQL be a better language for the conversion?

Anyone?

Ray K (4/20/2010)

---

Jake Shelton (4/19/2010)

---

I think a better way for the OP to have put it would be "SOLELY a DBA", and in that sense there are very few DBA's...

skjoldtc (4/19/2010)

---

The "true" part gets me. What does THAT mean? I have never seen a definition of a "true" DBA nor met anyone who said they were. I have met...

"Dammit Jim, I'm a DBA, not a(n) (insert impromptu but infuriatingly all-too frequent job responsibility title here) !"

🙂

I only counted one on BOL, that's the walkthrough where you create a package to do a straight csv-db copy for two columns, and lookups for the other two, with...

Appreciated!

Hi Ivan,

Fair enough, if you go Start-Programs etc. to the BOL tutorial for 2005, it takes you through the creation of a 'simple' etl package, and here's the point at...

Well, look on the bright side, if RS or (anything about IT) were straightforward, the users would do it themselves and we wouldn't be able to pay our ex-wives any...

All done, I created a user (with limited rights), all the red lights are now green.

🙂

Hi George, checked those logs, it looks like everything points back to the ASP account as the root cause - whatever ASP is, I'll look it up. Got this...

Hi Jack,

Yes, at your suggestion I've taken the defaults for the Virtual Directory settings - have to say the process to get to them was a tad unintuitive - and...

*gives Lynn a big kiss for saving me a whole w/ends work...* 🙂