开发者

Using SSIS Package Configuration to change flat file path?

开发者 https://www.devze.com 2023-01-31 12:37 出处:网络
I want to use the SSIS Package Configuration to change the path of several flat file destinations, but only the path, not the filename.Basically I have alot of flat files going to the same directory,

I want to use the SSIS Package Configuration to change the path of several flat file destinations, but only the path, not the filename. Basically I have alot of flat files going to the same directory, but each has it's own name. Unfortunately the property on the flat file object includes both the filename and directory as one string. I would like to set it up so it is easy to change the directory f开发者_Go百科or all of these, but where they still have their own unique filename.

Any ideas? Can this be done somehow with expressions?


Yes, can be done with Expressions.

  • Define a package variable for Path
  • Define an expression for ConnectionString with @[User:Path] + "\filename"
  • Use a package config to define the variable (or on command line)

I don't have SSIS on this PC so no screenies, sorry. Check this and this though

0

精彩评论

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

关注公众号