DTS Fails on Upsized Database

From: Bob Hoeppner (bobahop_at_devdex.com)
Date: 06/03/04 

Date: Thu, 03 Jun 2004 07:08:36 -0700

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!

Relevant Pages

  • Re: setting DTS Global Variables
    ... I would like to execute the DTS from the command line, ... I do not want to change the database object names ... >> destination of the file to a different server through code. ...
    (microsoft.public.sqlserver.dts)
  • Re: DST to copy from one database to another, but using a JOIN across them.
    ... Server 1 to Database B on Server 2. ... I would like this to be a DTS task (so that Many tables can be updated ... INSERT INTO tblCompany(CompanyID, CompanyName, PrimaryPerson) ...
    (microsoft.public.sqlserver.dts)
  • DTS transfers only objects, not data!
    ... I use DTS to transfer database from one server to another. ... I created DTS package which imports ...
    (microsoft.public.sqlserver.dts)
  • Re: SETUSER Permission Denied
    ... fire dts. ... > I am trying to use DTS to move an SQL Server database, ... > db_owner access to the database in B I am transferring data and objects ... > Also I have noted that while the tables owner is DBO, ...
    (microsoft.public.sqlserver.dts)
  • Re: Link Table Error
    ... > I created the database and later i upsize the database on sql 2000 server. ...
    (microsoft.public.access.gettingstarted)