Re: DTS error
- From: Sue Hoegemeier <Sue_H@xxxxxxxxxxxxx>
- Date: Tue, 05 Apr 2005 05:48:21 -0600
Don't think it's exposed for the Copy Objects and Data
between SQL Servers which is the option it seems like you
are using.
It's exposed with the Copy Tables and Views option but there
is no where to specify replace existing data as you can in
the Copy Objects option of the wizard. You'd probably have
to write your own package to handle qualifying object owners
and replacing data.
-Sue
On Mon, 4 Apr 2005 22:13:46 -0400, "shank"
<shank@xxxxxxxxxxxxxxx> wrote:
>How do I qualify object owners in the DTS wizard? Using the GUI, I never saw
>such an option.
>thanks
>
>"Sue Hoegemeier" <Sue_H@xxxxxxxxxxxxx> wrote in message
>news:cfn351tbnk2ea274se3cj943cjs170hjks@xxxxxxxxxx
>> Yes...the different owners is probably the issue. Remotely,
>> it's looking for dbo.Prices. You need to qualify the table
>> names with an owner such as Owner.TableName.
>>
>> -Sue
>>
>> On Mon, 4 Apr 2005 17:09:43 -0400, "shank"
>> <shank@xxxxxxxxxxxxxxx> wrote:
>>
>>>I'm trying to use DTS to transfer data from a local SQL Database up to a
>>>remote SQL Database. I get the following error. I'm trying to replace the
>>>data. Both database are named the same, tables the same and the table
>>>structures are exactly the same. Locally, the owner is 'dbo'. Remotely,
>>>the
>>>own is 'bob'. Is this the issue? Doesn't seem like it should be. How can I
>>>resolve this?
>>>thanks
>>>
>>>Microsoft SQL-DMO (ODBC SQLState: 42502)
>>>[Microsoft][ODBC SQL Server Driver][SQL Server]Could not truncate 'Prices'
>>>because this table does not exist in database 'Prices'.
>>>
>>
>
.
- Follow-Ups:
- Re: DTS error
- From: shank
- Re: DTS error
- References:
- DTS error
- From: shank
- Re: DTS error
- From: Sue Hoegemeier
- Re: DTS error
- From: shank
- DTS error
- Prev by Date: Re: accessing secured excel document
- Next by Date: Re: 2005 SSIS Question
- Previous by thread: Re: DTS error
- Next by thread: Re: DTS error
- Index(es):
Relevant Pages
|
