DTS consistently fails on my SQL Server 2K database upsized from Access.
Whether I upsize to an existing SQL database or create a new one, DTS
fails with the following error when I try to copy SQL Server objects
from that database to another database (both on the same server):

"Need to run the object to perform this operation." [SQL-DMO]Code
execution exception: EXCEPTION_ACCESS_VIOLATION

The error suggests that the server is not being found, but DTS works on
all other DBs on the same server. I can create a DB, create a table in
it, and successfully DTS the table from it. If I upsize from Access to
the same DB (whether I upsize one table or all of them) I can no longer
DTS from that DB (not even the table I successfully DTS'd before.) I've
tried saving the DTS package in VB to try to step through it, to no
avail. I've tried specifying the server instead of using (local) to no
avail. I've tried many combinations of checking and unchecking various
options, to no avail. I've tried rebooting SQL Server between upsizing
and DTSing, to no avail. I've never had a problem DTSing schema before.
Anybody know what gives?

I would like to not have to upsize from Access to create each CSD, but
that would be my kludge if I can't get DTS to work.



*** Sent via Devdex http://www.devdex.com ***
Don't just participate in USENET...get rewarded for it!

Turns out I can DTS if I deselect the dependent objects and extended
properties options. These cause no problems with other DBs (or with the
same DB before upsizing one or more Access tables to it) but that's the
wacky world of software for ya'.



*** Sent via Devdex http://www.devdex.com ***
Don't just participate in USENET...get rewarded for it!