SQL Server 和 SSIS 权限问题？
大家好，我正在用这个把头撞在墙上，希望有人能提供帮助。我有一个用 BIDS 2005 编写的 ssis 包，它基本上从 DatabaseA 中的表中选择一些数据行，并将数据传输到 DatabaseB 中的表中。它是一个相当简单且简单的 SSIS 包。我已将我们的开发服务器（运行 sql server 2008 r2）上的软件包安装到集成服务中。当我使用用户名 (v_ashby-smith) 登录服务器并直接通过集成服务运行包时，包成功完成并按预期移动数据。
我希望该包按计划运行，因此我在 sql server 代理下创建了一个作业。现在，当我运行该作业时，包表示它已成功完成，但是在检查目标数据库表（DatabaseB）时，表中的所有数据都已被擦除！ SSIS 包不会执行任何类型的删除，它实际上只是复制数据。 sql server 代理服务已设置为作为域用户 COMPANY\devsqladm 运行，并且已在 sql server 中创建了一个具有访问所需数据库所需权限的用户。
更令人困惑的是，当我在 BIDS 中运行该包时，它工作正常并按预期复制数据！
如果有人有任何想法，我真的很感激，这应该比结果简单得多！
Hi all i'm banging my head against a wall with this one and hope someone can help. I have a ssis package written in BIDS 2005, which basically selects some data rows from a table in DatabaseA and transfers the data to a table in DatabaseB. Its a fairly straightforward and easy SSIS package. I've installed the package on our dev server (which is running sql server 2008 r2) into integration services. When i'm logged onto the server with my username (v_ashby-smith) and run the package directly through integration services, the package completes successfully and moves the data across as expected.
I want the package to run on a schedule so i've created a job under sql server agent. Now when i run the job the package says it completes successfully, however when inspecting the destination database table (DatabaseB), all the data in the table has been wiped!! The SSIS package does not do any sort of delete it literally just copies data across. The sql server agent services has been set to run as a domain user COMPANY\devsqladm and a user in sql server has been created with the necessary permissions to access the required databases.
To also add to the puzzle, when i run the package in BIDS, it works fine and copies the data across as expected!
If anyone has any ideas i would really appreciate it, this should be alot simpler than it is turning out to be!!
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
默认情况下，SSIS 包或 SQL 代理都会删除任何内容...删除要么发生在包内部（如果您选择“删除行”选项，这通常是第一个任务），要么有一个删除逻辑作为代理中的单独步骤。
您可能想要运行探查器来查看到底调用了什么。或者尝试删除用户的删除权限以查看包是否失败。
不幸的是，所提供的信息还不够。
SSIS Package nor SQL Agent deletes anything by default... the deletion is either happening inside the package (which is usually the first task if you selected "delete rows" option) or there's a delete logic as a separate step in the agent.
You might want to run the profiler to see what exactly is being called. Or maybe try remove delete permissions from the user to see if the package fails.
Unfortunately, the information given is not enough.