Error at Transfer Objects Task: The source server can not be the same as the destination server.

Hot Topic

Secure Social Security number in my DataBase
Execute SSIS package without SSIS console
How to execute backup file?
SSIS will not start after SQL Server 2005 SP1 upgrade
Execute phase Memory Error
Database Diagram
Questions about SQL Express
Only transform unique rows
SQL Express user permissions?
converting to a uniqueidentifier

SQL Server

web users log-in
Using stored procedure or not?
Analysis services
Capturing Processing Status and Progress Messages
How to display milliseconds as part of datetime field?
Is there any sample code which creates login and user of one database using SMO?
How to programically call SSRS 2005 report then Save to file
SQL Server Express will not install.
Help with pointing to an image!
INCORRECT DATA WHEN USING MOLAP AND HOLAP STORAGE.

Error at Transfer Objects Task: The source server can not be the same as the destination server.

SQL Server 2005 - June CTP

Error at Transfer Objects Task [Transfer Objects Task]: The source server can not be the same as the destination server.

Why not I'm trying to transfer a set of tables from one database to another. Both databases happen to be on the same server. I understand that the source *database* cannot be the same as the destination *database*. But why can't I use the Transfer Objects task to transfer objects from one database to another on the same server

Thanks for your help!




Answer this question

Error at Transfer Objects Task: The source server can not be the same as the destination server.

  • JAson_scoobyjw

    I can easily reproduce this. I would agree with Joseph, moving between databases on the same server is a legitamate requirement.

    -Jamie


  • aajrb

    As far as I can see, with the production release of VS 2005, the original bug which I reported 'the source server cannot be the same as the destination server' has been corrected. I just used the Transfer SQL Server Objects task to transfer all objects (i.e. Tables, Views, Data, Indexes, etc.) from one database to another on the same server.

    What 'issues' specifically are you encountering

    - Joe Geretz -



  • Bose39814

    Dear Sharma,

    Could you please update everyone whether the bug is resolved or yet to be resolved as we are facing a lot of issues in this task even after installing Service Pack Sp1.

    Thanks,

    Pradeep

    +91 99451 20960

    Pradeep.au@gmail.com



  • Jose Miguel Torres

    I bumped into this problem several weeks ago and was only told "there are known problems with the transfer objects task"

    My work around is to use an execute sql task that uses a fully qualified Insert statement to insert records into database 2 from database 1

    Insert database2.dbo.tableA  select * from database1.dbo.tableA

    While it is a royal pain to have to have a line per table (250+ tables..changing on a regular basis) it does work and I get my records from the staging DB to the production

    Paul Pisarek

  • Alexb1115

    Paul,

    Sorry about the curt response. Please reactivate the bug and follow through until you're satisfied with either the explaination or the resolution.

    thanks,
    ash

  • Error at Transfer Objects Task: The source server can not be the same as the destination server.
Answer this question