Paul,

Not sure but it sounds like an ODBC type error. Has the server had any patches applied (what with the recent virus attacks and all) recently that may have damaged/updated...

Would all the meetings be done in NetMeeting????

Blair,

Nigel's solution is probably the preferred method. I have found that using Lookups tends to be slow at best!

Good luck,

Darrell

I get lucky once in a while!!

Glad to be of assistance.

Mark,

We have SP4 on all of our SQL Servers and have not had any issues (yet!!!).

Chris,

We have not done the AWE hotfix -...

Martin,

Try this - DTSGlobalVariables("Counter").Value = CINT(DTSGlobalVariables("Counter").Value) + 1

Good Luck,

Darrell

Tim,

Are yo telling me to put down my extra glaze donut and wash my hands before touching your keyboard??

This is starting to sound an...

But if I don't touch the screen how do I know you are looking at what I am talking about!!!!

M,

Sorry for the delay getting back to you - darn paying job keeps interupting!!

sushila - I agree wholeheartedly!!!!

Looks like you folks have about...

M,

I will tackle the easy one first - considering the last page is a "summary" of all the fields the user can/wants to add, I would do the insert from...

Markus,

You are correct that it can be db specific. You can even go as far as column specific with SQL2000. Be careful of what you ask for though because it...

I use a tool called DTSBackup2000 that is quite nice and easy to use. I have scheduled the backups of all DTS packages on the servers and so far so...

Tried asking at the last job - I knew they were being VERY lean with the percentages so I took the approach of "no increase - more vacation". Did not like...

What's a person if they don't have dreams!!! 🙂

You could also create a view of the required fields from the 4 tables and use the sp to query from the view.

Good Luck,

Darrell