Got it! I have to run the whole package for logging to be recorded, even though I can set up logging for just part of it. That was the piece...

This time when I opened SSMS, sysdtslog90 is there! I really did try Refresh.

If I click on the package and select Execute Package logging works. It doesn't, if I...

I've made some progress. 🙂 I ran the package in debug mode and it created the sysdtslog90 table. It does not display in Management Studio, but I can query it....

Sorry it takes me so long to get back to this.

There are no tables in the database. I figured out how to run the default trace, and that shows...

It's a 32-bit system.

We're going to create a separate development server with just the database the consultant needs, so we can give him admin rights on that. That solves...

FYI, it is a problem with the Windows group.

Thanks for the help!

Linda

Yep, I did that. And the user was an existing member of the group.

I did not assign the group a database role membership. In Securables, I added the Dow schema...

2. I like easy answers like that.

1. I'm not sure, it's an account in our WIndows domain, that has access to a specific folder and no one who is not...

Thanks for the suggestions. A datapump from a vendor had loaded a lot of temp files under my user id. We deleted those and are trying again.

Linda

That sounds like what I need. With directions I can understand. 🙂

Thanks!

Linda

Thanks for your help. I think I'll start with one of our small dbs and monitor it for a bit, then do the others.

Linda

Thanks, this is starting to make sense now. Just one more question. (I hope 🙂

If the mirror never becomes the principle, will the transaction log just keep growing? Do I...

OK. Can I have a copy of the job on the mirror server, so that I could just schedule the job and not have to recreate, if the mirror became...

Jeff, I agree there should be a better way, but since the people who own the application like their datapump (I've talked to their tech support), I'm stuck with it....

Thanks for the suggestions. I've changed the db to bulk-load, but don't know if that'll help in the middle of the process. I'll try removing the primary key constraint on...