I created a DTS package to download my data off a shared SQL server. It runs
for a while then stops with an error. There's no such user as "bill". I
assume that it stopped because bill is an owner online, but not on my local
drive. Here's what I've tried...

1) I created a new user bill under BUILTIN/Administrators - still didn't
work
2) I tried only grabbing either tables or SPs - still didn't work
3) I tried unflagging all the user, permissions, login, indexes etc.
options - still didn't work

I tried changing owners, but it appears that doesn't work with shared
servers. I think I have to be part of the sysadmin or something.

What's left to try?
What am I doing wrong?

thanks!