Wednesday, March 7, 2012

File System Task - relative location ?

hi,

I am using "File System Task" to copy files from one pre-defined location to another.

Is there a way to provide a "relative path" for the corresponding connections? If yes, how to set it up for deployment?

If not, I guess the option will be to update the "connection string" property for the file connections using package configurations.

thanks,
NiteshAnother option is to store the "root" location in a folder (it can be populated from a configuration) and you can then use property expressions on your file connection manager connection strings to use that variable.

-Jamie

No comments:

Post a Comment