问题描述
我创建了 SSIS 包并使用集成服务部署向导将其部署到服务器.我将通过 SQL Server 2012 手动转到 Integration Services 目录访问,然后右键单击并执行我的包.
但是,包一直失败,当我检查执行报告的消息时,我收到以下错误.
他们似乎在我有脚本组件的数据任务上失败了.
分配:错误:CS2001 - 找不到源文件C:\Windows\TEMP.NETFramework,Version=v4.0.AssemblyAttributes.cs",CSC, 0, 0
分配:错误:无法编译包中包含的脚本.在 SSIS 设计器中打开包并解决编译错误.
这个答案是 UberDoodles 答案的更详细版本.
在 Windows 资源管理器中.
- 导航到
C:\Windows\Temp\
- 右键单击文件夹并选择
properties
- 转到标签
Security
,选择Advanced
- 在默认选项卡
Permissions
上,选择Change Permissions
- 对于相关的权限条目,选择
edit
. - 默认情况下,我为
遍历文件夹/执行文件
、创建文件/写入数据
和创建文件夹/附加数据
选中了允许">. - 还要为
列出文件夹/读取数据
和取得所有权
勾选允许". - 按确定,窗口关闭
- 按应用并确认您需要的任何内容.
此外,登录用户已经拥有完全控制权,但是当我为用户"条目更改此设置时,它对我有用.
(基于 微软文件/文件夹权限)..>
I created SSIS packages and used the Integration Services Deployment Wizard to deploy it out to the server. I'm manually going to the Integration Services Catalog access through SQL Server 2012 and right-clicking and executing my package.
However, the package keeps failing and I'm getting the following errors when I check the execution report's messages.
They appear to be failing on data tasks where I have script components.
This answer is a more detailed version of UberDoodles answer.
In Windows Explorer.
- Navigate to
C:\Windows\Temp\
- Right click the folder and select
properties
- Go to tab
Security
, chooseAdvanced
- On the default tab
Permissions
, chooseChange Permissions
- For the relevant Permission entry, choose
edit
. - By default, I had 'allow' checked for
Traverse folder / execute file
,Create files / write data
andCreate folders / append data
. - Also check 'allow' for
List folder / read data
andTake ownership
. - Press OK, the window closes
- Press Apply and confirm anything you need.
Additionally, the logged in user had already Full control, but when I changed this for the entry 'Users', it worked for me.
(based on microsoft file/folder permissions).
这篇关于CS2001 执行部署到服务器的 SSIS 包时缺少 AssemblyAttributes.cs的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!