Put the name of your virtual server in the 'Select counters from computer:' and you'll find the 'Performance objects' you are looking for.

btw. Which do you typically monitor, and why?

Here is an example of an activeX step you could add to your DTS package to copy one file from a directory to another directory (with a common name, in...

Intresting question, I don't work much with parameters in SQL tasks, perhaps I've run into some of the same issues.  This is a bit different that the path you were...

Variable filenames..

I move file(s) from an FTP server to a directory called "source" (Using ActiveX fso and a loop).  The file name looks like:

Data20051214_950.csv

After moving all the files from FTP the...

Is this error occuring during a "Transform Data Task"?  The easiest way I've found to find rows that error in a large import is to go to the "Options" tab in...

Mine is manual now, but could easily be added to Schduled Tasks if you knew when the file would be available.

SQLServer creates the file as part of a sheduled job

The...

AFAIK, you would need Excel installed.  I have a similar required process (monthly)  I currently run the DTS package, grab the file to my local system (where I have Excel...

I solve sort issues like this by adding another column like 'LetterSort', don't know if that's an option for you.

Cheers..

When I need this information I am able to get it from the exception file.  I use 7.0 format and it contains the number of failed rows and the row...

Both RAID arrays need to be cluster resources before SQL can use them. Are both disks in Cluster Administrator?

(At least for me with IBM serverRAID)

Won't DTS only create the tables and populate them? What about indexes and keys constraints and trigger? (unless you script that first) Guess I'd have to know what "copy...

"I have seen comments here in the past as I'm sure you have where people have complained about poor results when SQL files are placed on a SAN."

sjcsystems, can you...