Thanks for the response, but as I mentioned in my initial post, I can't delete all the records in the Production database.

There are a few products on the market for this now.

A couple of the better offerings are available here,

http://www.xpressapps.com

http://www.skilledsoftware.com

First step would be to put togther a VB or VBScript program to programmatically open each package, change the required properties and then save the package.

Second step is to change...

Try using SQL-DMO via VBA.

Because of SQL Servers relative youth when compared to Oracle, there's not much in the way of Enterprise class management.

There are a few web based offerings, but most of them...

Antares, you're usually spot-on with your prompt replies. However this time I think your promptness has got the better of you.

The IDn files are for the indexes. ID1 is clustered...

I must admit it's not that easy to get to.

1) Bring the properties for the Matrix (not the report)

2) Select the "Group" tab

3) Select the group to change in the...

We do this regularly in a number of packages. All in an ActiveScript task.

The filename is stored in a global variable which is used when attaching the file to the...

FOr the "A previous program installation ..." message, clear out the temp directory before running the setup program.

It's supposed to be cleared when you reboot, but sometimes it isn't.

Based on a few unrelated google messages about MS Access and password protection, I decided to set the userid and password parameters each time I changed the datasource.

This seems to...

Turning on Client Statistics in Query Analyzer gives you the following info on a seperate tab,

Application Profile Statistics

Timer resolution (milliseconds)00

Number of INSERT, UPDATE, DELETE statements00

...

I've done that and all is ok.

After further testing I've found that it seems to occur about 1 in 4 times.

Could it be a timing issue?

If you're running these queries in Query Analyzer, turn on Client Statistics (Ctrl+Shift+K).

The delay you're experiencing is probably due to the client formatting the output.

Also, make sure you are not...

You can't attach query results using CDONTS.

Extract the results to a file and then attached the file.

See my post in the T-SQL group.