Post reply

Transfer data from Sql2005 to sql2000

  • August 31, 2009 at 11:51 pm

    #141331

    Hi,

    I run into an issue with SSIS.

    I'm trying to copy data from a db on sql 2005 SP2 to sql2000 using Transfer SQL server object.

    I set

    CopyData = TRUE

    ExistingData = Replace

    and specify the table to copy.

    When I run the task as SA it empties the taget table and then inserts the data.

    When I run the task as db_owner plus different combinations (ddl_admin among others), it transfers the data but it appends it to the target table instead of truncating first.

    Doesn't db_owner have truncate rights? When I manually truncate the table it works.

    What have I missed?

    How should the task be set up?

    Thanks for any help or input

    /ricfors

  • September 1, 2009 at 2:27 am

    #1047349

    Duplicate post. No replies to this thread please. Direct replies to:http://www.sqlservercentral.com/Forums/Topic780445-148-1.aspx

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

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

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