开发者

How to change the flatfile connection manager "file name" value in SSIS package?

开发者 https://www.devze.com 2023-02-21 18:39 出处:网络
I havean ssis package...which read data from fixed-column-width text file into DB table. And I am modifying an existing ssis package.

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...开发者_Go百科it rollback

Help me please.


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 check Expressions to see if the ConnectionString is 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.

0

精彩评论

暂无评论...
验证码 换一张
取 消

关注公众号