如何更改平面文件连接管理器“文件名” SSIS 包中的值？
我有一个 ssis 包...它将数据从固定列宽文本文件读取到数据库表中。
我正在修改现有的 ssis 包。 我有一个平面文件源...和平面文件连接。当我尝试编辑平面文件连接...使用“平面文件连接管理器编辑器”...在“常规”部分下...即使我选择不同的文件名..它也没有得到反映。
或者...选择“平面文件连接”的属性窗口 - 一旦我更改连接字符串并单击 Visual Studio 的“保存”...它会回滚
请帮助我。
I have an ssis package...which read data from fixed-column-width text file into DB table.
And I am modifying an existing ssis package.
I have a flat file source...and flat file cnnection. When I try to edit the flat file connection...using "flat file connection manager editor"..., under "general" part...even if I select different filename..it's not getting reflected.
OR...select the properties window of "Flat File Connection" - once I change connection string and click "save" of visual studio...it rollback
Help me please.
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（2）
将有用的注释放入答案中...
连接字符串（文件路径、名称）可能是从表达式/用户或项目参数设置的。
要进行检查，请右键单击平面文件连接管理器并转到
Properties，然后检查Expressions以查看ConnectionString是否是从诸如@[User::MyFileConnectionString]之类的变量，在您手动更改它后，这会导致它的行为看起来“不执行”。
Pulling a useful comment into an answer...
It's possible that that Connection string (the file path, name) is set from an expression/user or project parameter.
To check, right-click the flat-file connection manager and go to
Properties, then checkExpressionsto see if theConnectionStringis set from a variable such as@[User::MyFileConnectionString]That would cause this behavior of it seemingly "un-doing" after you change it manually.
您是否可能无权访问包本身？右键单击下面的连接管理器中的文件图标并选择“重命名”，然后在此处重命名，然后保存包应该可以工作。
Is it possible you don't have access to the package itself? Right clicking on the file icon in the Connection Manager below and selecting 'Rename' and then renaming it right there and then saving the package should work.