Pls post, I took it in Beta and live (and wrote the Sybex book on it).

Steve Jones

steve@dkranch.net

jamyer is right. Just connecting in EM runs quite a few queries. Same for the first time you open most folders in EM. Increase your timeouts.

Steve Jones

steve@dkranch.net

You're welcome and good luck. Looking forward to seeing you around.

Steve Jones

steve@dkranch.net

Looks like you are using SQL auth. Is the server set for SQL Auth? or NT only?

Steve Jones

steve@dkranch.net

I thought it would be slower. It is a better alternative if you have a very large database, but if you can get your backup onto a disk, I'd go...

I sed to be a network admin (10-11 years ago) and got stuck doing some DBA work and enjoyed ut. I then did software development for 3-4 years while still...

I agree with Andy. You don't really want an email from a trigger as if email hangs, the transaction hangs. Or if email fails, then your insert or update could...

If any task in DTS fails, you get a failure. Annoying when you don't care about certain tasks. I've setup an alert(email) in the package that let's me know nothing...

What type of tape setup? Haven't seen any that compare to disk.

Steve Jones

steve@dkranch.net

Interesting definitions. Thanks.

Steve Jones

steve@dkranch.net

I don't think the dynamic task will do this. If you want to work with files, you need the file system object. See my Push FTP article for an example....

It willl help if you can post the table and explain exactly where each piece of data is.

You probably want a task rather than a trigger, but until you define...

Try:http://www.quest.com/datafactory/index.asp

Steve Jones

steve@dkranch.net

You can look at my article on PushFTP. This could be easily altered to do renames instead, however, you need to know the file names. If you do not know...

You can also make the change in em, then click the script button. It will allow you to save a script of your changes and you can examine this.

Steve Jones

steve@dkranch.net