You could add an ActiveX Script task that check the properties of the datapump task. This way you'll not only get a count of the rows processed but also the...

How is the file created?

You might be able to use the filename as your key and add it in as an ActiveX Script transformation.

If you don't have Visual Studio .Net download and install the Script Debugger

http://msdn.microsoft.com/library/default.asp?url=/downloads/list/webdev.asp

Then turn-on Just-in-Time debugging by right clicking on the 'Data Transformation Services' and selecting Properties.

Put a...

You use counter logs in much the same way the NT performance monitor logged counters to a file. The only difference is that you've got a few extra options.

To create...

Never liked points systems, there is always more than one way to skin a cat.

Also, what I see a lot of in the DBA world is a quick response that...

quote:

---

I have not collected other statistics, partially because I know the load on the machine, disk, and network is low at that...

quote:

---

quote:

---

given your answers to our questions and suggestions, I'd say you'll have to "roll...

Look for the line

goPackage.SaveToSQLServer

in the VB file. Check Books Online for the full syntax. Be aware that you'll lose the layout of the tasks and any...

wodom, given your answers to our questions and suggestions, I'd say you'll have to "roll your own" maintenance plan.

In a past life I had to do this for SQL 6.5...

You don't need to pass the filename to the job.

You can setup the DTS package to accept a global variable eg:the file path. Then your DTS package checks if the...

I wouldn't say you should never use cursors, just be aware of their pitfalls and avoid them when more efficient methods are available.

Check the following topic in Books Online,

"Optimizing Application...

quote:

---

Not sure about all the changes, but we have an article coming in the Jan issue of SQL Server Standard (http://www.sqlserverstandard.com/). Not...

I would suspect a dodgy or incorrectly set terminators. I've successfully used BULK INSERT to import files that are 100's of Mb's.

See if you can import the file using...

How are you updating the table? Using a stored procedure in an ExecuteSQL task, you can return the value of @@ROWCOUNT to a global variable.

Hope this helps

Phill Carter

--------------------

Colt 45 -...

The backup priority can't be changed.

What options have you used in setting up the maintenance plan? The 'Reorganize Data...' option can cause timeouts while sqlmaint performs a dbreindex.

It sounds...