had the same issue, running:

USE xxxx

EXEC sp_changedbowner 'sa'

fixed the error

Very good Vincent, that makes sense to me. Care to share any other items you ran into in that approach or did it work pretty well all in all for...

Good article Vincent! I just came across this researching our options for our 2005 conversion. It appears from your article, that you brought over your DTS packages to 2005 and...

Actually I never resolved this fully, but I did determine that Reporting Services had been installed/reinstalled incorrectly on this machine which caused a number of issues. There is a set...

You folks gave me the info I was needing, sorry I did not reply sooner, our email filter has been blocking this bits of useful information. Thank you for your...

I changed jobs 3 years ago, and fortunately for me my new employer is very supportive in keeping our skills current. I have attended a few conferences, TechEd the past...

Colin, which Administrators Pocket Handbook are you referring to??

Hello, as the other's have mentioned you have the ability in EM to do this, but it has its problems/limitations. We have found that in saving the files as a...

Yes you need to be aware of how the encrypted keys are handled. Someone moved our QA reporting services server to a differnet server and did not follow the proper...

Hi Brian, I noticed you said there were no competitors for sqlsentry, Idera has a SQLSchedule tool, have you looked at that? I believe it has a lot of the...

Idera has a tool they sell that will help you keep track of jobs, go to http://www.idera.com, look at sqlschedule 2.0

We have used Enterprise Architect from Sparx systems. It is a very nice tool and very reasonably priced. You should check it out http://www.sparxsystems.com.au/

Hello, here we also use SourceSafe to manage our DTS packages saving them as a sturctured storage file. That way we have additional version control along with knowing they are...

Thanks for the info Jules, I plan to make this a little more generic for use in other packages, it just seemed so cumbersome for something that would be so...

"I found a nifty new use for the dynamic properties task.  I use it to manage step precedence bases and values in a package that requires the dynamic skipping of...