Post reply

Transfer Database Task Using SSIS

  • April 15, 2009 at 1:04 pm

    #133054

    I was trying to use this wizard to tranfer a Production database from Production to Test server. But I'm getting folowwing error. Can any help me in this regard

    Thank you

    Error:

    SSIS package "Package.dtsx" starting.

    Error: 0xC0024104 at Transfer Database Task: The Execute method on the task returned error code 0x80131500 (ERROR : errorCode=0 description=CREATE DATABASE failed. Some file names listed could not be created. Check related errors. helpFile= helpContext=0 idofInterfaceWithError={8BDFE893-E9D8-4D23-9739-DA807BCDC2AC}). The Execute method must succeed, and indicate the result using an "out" parameter.

    Task failed: Transfer Database Task

    SSIS package "Package.dtsx" finished: Failure.

  • May 14, 2009 at 9:21 pm

    #995033

    Hi - I am getting exactly the same error and it is driving me nuts trying to resolve - seems ssis does not like the fact that the database is already created on the target area - did you work this one out ?

    Thanks

  • May 15, 2009 at 9:09 am

    #995419

    davidr (5/14/2009)

    Hi - I am getting exactly the same error and it is driving me nuts trying to resolve - seems ssis does not like the fact that the database is already created on the target area - did you work this one out ?

    Thanks

    What transfer method are you using and what are you selecting in the "Configure Destination Database" step ("Stop the transfer if a database or file with the same name exists at the destination" OR "Drop any database on the destination server with the same name, then continue with the database transfer, overwriting existing database files").

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

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