Post reply

error when using transfer DB task

  • December 22, 2008 at 10:32 pm

    #127631

    Hi I am receiving the following error when using the transfer database task in SSIS. My version of SSIS is 9.00.3042.00 and sql is at 9.00.3068.00

    Error: The Execute method on the task returned error code 0x80131500 (ERROR : errorCode=-1073548784 description=Executing the query "CREATE USER [sa2] FOR LOGIN [sa2] WITH DEFAULT_SCHEMA=[dbo] " failed with the following error: "'sa2' is not a valid login or you do not have permission.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly. helpFile= helpContext=0 idofInterfaceWithError={8BDFE893-E9D8-4D23-9739-DA807BCDC2AC}). The Execute method must succeed, and indicate the result using an "out" parameter.

    From my searches it seems this should be fixed with SP2. I believe both client component tools and sql are at SP2. Any idea how to fix this? Is there a hotfix I'm missing?

    Thanks,

    TKE402

  • December 23, 2008 at 5:54 am

    #916718

    Do you have sa2 login?

    ---
    SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

  • December 23, 2008 at 7:16 am

    #916748

    No. I don't know where it's coming up with SA2. I configured the SSIS package to use SA not SA2. A post from another user who was having the same issue found this after he ran profiler against the destination server:

    "when I run profiler against the destination sql server after running create database and then a few alter database to set it's option it immedielty tries Create Role without first considering the database it belongs to in the source."

    I'm not sure if this is what is casuing this error for me. I'm a newbie to this so I don't know how to interpret it. The post continues with the fix as upgrade client component tools to SP2. But I am already there. So could this be somthing else?

    Thanks

    TKE402

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

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