SSIS 2008 中的传输数据库任务
我正在尝试使用 SSIS 通过传输数据库任务将数据库从 SQL 2000 实例传输到 SQL 2008。
我已尝试了所有我能想到的方法来使其正常工作，包括使用对连接管理器中的两个数据库具有完全访问权限的帐户。然而，每次我尝试运行它时，我都会得到以下信息：
Information: 0x400292A8 at Transfer Customizations, Transfer Database Task: Overwriting the database "Customizations" on the destination server "Server2".
Error: 0xC0024104 at Transfer Customizations: The Execute method on the task returned error code 0x80131500 (ERROR : errorCode=-1073548784 description=Executing the query "EXEC dbo.sp_grantdbaccess @loginame = N'Reports', ..." failed with the following error: "'Reports' 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={C81DFC5A-3B22-4DA3-BD3B-10BF861A7F9C}). The Execute method must succeed, and indicate the result using an "out" parameter.
Task failed: Transfer Customizations
“报告”是具有只读访问权限的真实登录。但是，使用登录名（源）的第一台服务器甚至不在源的连接管理器中，因此我很困惑为什么它会出现在错误中。
有什么想法吗？
I am trying to use SSIS to transfer a database from a SQL 2000 instance to SQL 2008 using a Transfer Database Task.
I've tried everything that I can think of to get this to work including using accounts with full access to both databases in the Connection Managers. However, each time I try to run it, I get the following:
Information: 0x400292A8 at Transfer Customizations, Transfer Database Task: Overwriting the database "Customizations" on the destination server "Server2".
Error: 0xC0024104 at Transfer Customizations: The Execute method on the task returned error code 0x80131500 (ERROR : errorCode=-1073548784 description=Executing the query "EXEC dbo.sp_grantdbaccess @loginame = N'Reports', ..." failed with the following error: "'Reports' 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={C81DFC5A-3B22-4DA3-BD3B-10BF861A7F9C}). The Execute method must succeed, and indicate the result using an "out" parameter.
Task failed: Transfer Customizations
"Reports" is a real login with read only access. However, the 1st Server which uses the login (the source) isn't even in the connection manager for the source so I am confused as to why it comes up in the error.
Any ideas?
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
不太确定错误，但如果您只是想移动/复制数据库，那么分离并重新附加 MDF 文件可能会更容易。
这里有一个分步指南
Not too sure about the error but f you are just looking to move / copy a database then it may be easier just to detach and reattach the MDF file.
There is a step by step guid here