I played a lot of AD&D in the 80s, and though most of what we played was only loosely based on Gary's TSR materials, I am thankful of his pioneering...

The new script with BULK INSERT is working beautifully.

The perfectionist in me still wants to know how to fix the base DTS, and the practical person in me revels in...

Haha! I get what you are saying now. Thanks for expanding...

Thank you, Tomm,

The import data transformation was the second step in the base until I removed the first step. I put tracking emails into the base DTS and the step...

Re: [font="Times New Roman"]Two suggestions:

1. Add a log file in your package, so that you can find more detail information.

2. Check your fmt file and see whether or not any...

I have to be able to sleep at night.

I haven't had an employer error like that, and in 1981 I found $1200 in my savings account, almost a month's (tax...

I am my word.

When someone asks me to do something, I think about if I will/can do something or not before I make a commitment (or a refusal). People know...

Thank you for changing the picture, Steve, because I placed one meaning on the visual and another on the words, so I had confusion.

I am responsible for my feelings. If...

I work a 40 hour week now, with reasonable flexailty. My on call time is down now that automated processes at night have been stabalised and user departments are charged...

I'll go out on a limb: I haven't tested this, but what about cheating by putting the data from the 3 fields into a ##temp_table and using the ##temp_table in...

This is what I would do:

DECLARE @xp_status tinyint

EXEC @xp_status = master.dbo.xp_sendmail 'Recipient@email.here.com'

, @Subject = 'This is the Subject'

, @message =...

Ok. I can't resist...

"PS, here are the answers:

•Father of the Internet - Vint Cerf"

Then how come we "surf" the internet and not "Cerf" the internet?

~Michael T

I created a SQL table which I allow specific users to insert to. Each user has a spreadsheet with a control button which inserts a request into the SQL table....

Hi Jeff,

Thank you for boasting about your Father. I think given that yesterday was a day to honour our Fathers your timing was right on. I am extremely happy to...

I'm in with the Air Car (the hybrid, OneCAT Model, anyhow).

http://theaircar.com

~Michael T.