Database Transfer Task Error

Question

Post reply

Database Transfer Task Error

Jacqueline Moody

SSC Enthusiast

Points: 165
More actions
March 13, 2006 at 7:19 am

#113226

I am starting to work with SSIS and would like to get a copy of a database from SQL 2000 to SQL 2005. I have been able to make it work using the wizard, which gives me a dataflow with source and destination, but this is not quite what I'm looking for.
I would like to use the database transfer task as this seems to do exactly what I'm looking for, but I get this error every time:
Error: The execute method on the task returned error code 0x80131500 (Script failed for ApplicationRole 'Report Service'.). The execute method must succeed, and indicate the result using an "out" parameter.
My connections on both the 2000 server and 2005 server are both configured to use the SA account.
Can someone point me in the right direction to get this working? It seems like it should be a very simple task.
Thank you,
Jacqueline
March 16, 2006 at 8:00 am

This was removed by the editor as SPAM

Viewing 10 posts - 1 through 9 (of 9 total)

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

Jacqueline Moody SSC Enthusiast Points: 165 More actions · Answer 1

I still need help with this if anyone can assist.

Thank you!

Alexander G. SSCrazy Points: 2705 More actions · Answer 2

Microsoft suggests that this is an error and should be fixed by SQL Server 2005 SP2:

http://www.eggheadcafe.com/aspnet_answers/SQLServerintegrationsvcs/May2006/post26942448.asp

HTH

Alexander

Alexander G. SSCrazy Points: 2705 More actions · Answer 3

Sorry, wrong link:

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1059616&SiteID=1

Jacqueline Moody SSC Enthusiast Points: 165 More actions · Answer 4

Thanks so much! I will d/l and get it installed tomorrow.

Chuck Rivel SSCrazy Points: 2991 More actions · Answer 5

Jacqueline

I am curious, did downloading SP2 help you with this SSIS task? I am currently working with a client and we are running into issues stating that the user currently exists when the task should overwrite the database entirely. The client currently only has SP1 installed on their SQL machines.

I would be interested to hear of your results.

Thanks!

Jacqueline Moody SSC Enthusiast Points: 165 More actions · Answer 6

Hi, Chuck. I don't know yet. I got it d/l'd and asked the server tech to patch it. He applied some other patch first and SQL Services did not start on their own, so he didn't apply SP2a yet. I restarted the server this morning and SQL came up ok on its own, so I think it was just in the middle of patching when he rebooted. Hopefully he'll get it patched after hours tonight.

Chuck Rivel SSCrazy Points: 2991 More actions · Answer 7

Jacqueline

Just a follow up, my client did apply the SP2a to their SQL Servers and this task worked successfully, provided I had the database users already created on the destination server.

Hope you are just as successful.

Chuck

Jacqueline Moody SSC Enthusiast Points: 165 More actions · Answer 8

That's great to hear, Chuck! Its not a problem creating the user ahead of time. I was given another delay installing the patch over the weekend, so hopefully tonight they'll get it done.