This is a very good article. The ideas fully apply to 2000, 2005 and will to 2008. And also to any application development: Do not hardcode the changable stuff.

One comment:...

Thanks you SO MUCH.

I will try it today!

Thanks Ed!

Hi David,

You can save DTS package as VB file - when doing Save as.

You can open this file with Notepad. Also if you copy all of these files to one...

Yes, that is a good solution - save as VB files and search them.

Does somebody know how to export text for 400 packages?

Vidhya,

David needs the table names, not the package name.

Hello Berto,

You have to either run sp_addlinkedsrvlogin or use Management Studio, go to your linked server and specify the remote login that correspond the local login that is trying to...

If you are talking about the scheduled packages, probably you would like to create a server trace with:

Events:

T-SQL Batch Starting

Columns:

like textdata, start time and end time

Filter:

textdata LIKE %YourTableName%...

I don't get the answer. If you read the question on the website (not in the email, but on the website, it asks: "Largest Unit

How much information does a Yottabyte...

So agree with both Steve and Dave!

Additionally: do something for other people first. Or offer to help them....

Mike,

you have to work with the person who created this procedures or try to read the procedure text to understand that is going on.

At the very least, post here...

It may be your company's rules on Exchange or SMTP Relay

Hi mike,

what happens if you execute the procedures in Query Analyzer, not as a job - do they accept the date parameter correctly?

Also, What is the error message in the...

I don't like "Install Updates and Shutdown" when shutting down the computer. You need to go somewhere and instead you have to wait 10 min. I know you can change...

The answer may be Requirements document, "Validation Test Plan" , "Installation Plan" and as Jeff mentioned, a ticket system. Each change is caused by some requirement. You have to create...