Databases
StackOverflow2013
Postsdbo
POSSIS Transfer Database task cryptic error message 0x80131500
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POSSIS Transfer Database task cryptic error message 0x80131500
    primarykey
    data
    text
    <p>I am using SSIS with VS2010 (shell) and databases going from SQL Server 2005 (32 bit)to SQL Server 2012 (64 bit). I am developing directly on the destination server (not optimal, but it works).</p> <p>When I try to use the Transfer database task, it gives me an error message as follows: "Error: The Execute method on the task returned error code 0x80131500 (An error occurred while transferring data. See the inner exception for details.). The Execute method must succeed, and indicate the result using an "out" parameter." <img src="https://i.stack.imgur.com/AG254.png" alt="Error message"></p> <p>Here is the problem... how do I view an "inner exception"?? it is a GUI interface with no way to step through the code! I even tried <a href="https://stackoverflow.com/questions/5772667/how-to-create-an-error-log-or-custom-error-log-within-an-ssis-package/6155087#6155087">setting up logging</a> - it just logs the same useless error message.</p> <p>Microsoft has no information for this error code in their reference docs (that I could find).</p> <p>After googleing the error code, I saw others have this error code along with messages having to do with users, roles, and creating them. </p> <ul> <li>I double checked that I have sysadmin rights on both servers, and<br> logins on both. </li> <li>I tried the same Transfer Database task from each server to itself (with changeing database name) and <em>that</em> worked fine for both by themselves. </li> <li>I tried both DatabaseOnline and DatabaseOffline options. (same error both ways)</li> <li>I tried doing a "Transfer Logins" task before doing the transfer database task, that task worked, but not the Transfer databases task. Then it started throwing errors saying that the databases don't exist - which implies that I need to transfer logins AFTER I transfer databases.</li> </ul> <p>Here are my settings:<img src="https://i.stack.imgur.com/EVnOG.png" alt="enter image description here"></p> <p>What am I doing wrong? <strong>OR</strong> how can I get the "inner exception" message?</p> <p>Also, follow my post to Microsoft's forums here: <a href="http://social.technet.microsoft.com/Forums/en-US/sqlintegrationservices/thread/cda53c80-8da6-4ed1-898a-9f3ff8464ae2" rel="nofollow noreferrer">http://social.technet.microsoft.com/Forums/en-US/sqlintegrationservices/thread/cda53c80-8da6-4ed1-898a-9f3ff8464ae2</a></p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USCommunity
    1. USWatki02
    plurals
    1. PL
      singulars
      1. LTLinked
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    3. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POSSIS Transfer Database task cryptic error message 0x80131500
      1. This table or related slice is empty.
      1. VTUpMod
    1. COAfter you transfer the logins, can you remove those and give it a shot? Will that help in any way?
      singulars
      1. POSSIS Transfer Database task cryptic error message 0x80131500
      1. USrvphx
    2. COremove what? the logins I just transferred?
      singulars
      1. POSSIS Transfer Database task cryptic error message 0x80131500
      1. USWatki02
    3. COWhat all events are you logging? Just OnError and OnTaskFailed? Grab OnInformation and OnWarning as they might give an indication of what else going wrong. Another option might [DTLoggedExec](http://dtloggedexec.codeplex.com/) Never played with that task so I can't speak to the particulars of the error you're encountering
      singulars
      1. POSSIS Transfer Database task cryptic error message 0x80131500
      1. USbillinkc
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload