Post reply

DTS Importing problem

  • August 30, 2007 at 1:11 pm

    #73529

    I am importing a database from one SQL Server 2000 to another SQL Server 2000.

    The procedure fails with this error:

    [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'view_ultima_avaliacao_todas'

    This error occurs when he is transfering this view

    select

    sum(ch) as CH,c.solicitacao as idSolicitacao

    from

    contrato c inner join

    parcelas p on c.id = p.contrato

    where data_pagamento_nf > (select convert(datetime,convert(char(7),data_aval,111)+'/01') from view_ultima_avaliacao_todas av where av.idSolicitacao = c.solicitacao) and data_pagamento_nf < convert(datetime,convert(char(7),getdate(),111)+'/01')
    group by c.solicitacao

    The view view_ultima_avaliacao_todas exists in both databases.

    I can run and edit the first view in the two databases but I can´t transfer it from one database to the other

  • August 31, 2007 at 5:27 am

    #730713

    Are you using the Copy SQL Server Objects task?


    Ade

    A Freudian Slip is when you say one thing and mean your mother.
    For detail-enriched answers, ask detail-enriched questions...[/url]

  • August 31, 2007 at 6:57 am

    #730747

    I am using the DTS wizard/Import and using the option "Copy objects and data between SQL Server databases" and "include all dependent objects"

  • September 12, 2007 at 7:08 am

    #733086

    Can anyone help me ?

Viewing 4 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply