Change SSIS File System Connection

Hi,

i've been asked to move our ssis project to another machine
and i've a lot of file system connection whice i must rename them to the new path in the other machine.
there is away to rename the file system connection dynamic or i must go and rename one by one ?
thanks.You'll have to edit them one by one, but the good news is that when you are editing each one, you can use expressions to dynamically create the file path. You can also use package configurations to allow you to set the "base path" via an environment variable, XML file, etc...

You may also be able to open the .dtsx file, though, and use Search/Replace to alter the file paths.|||

Ok thanks i will use Search/Replace to alter the file paths but after it i will have to enter each package and test connection so it will work.

there is away to bypass it?

thanks.

|||Why do you have to test it so that it will work? If the file format is the same, changing the directory shouldn't have any impact.|||

what i meant was that if i move my project to another machine i have to enter each package and there enter to each connection to sql server or odbc edit them,test connection and save the package.

there is any way to skip those levels?

|||

Best solution is to take your own time and make use of config files so that you dont have to bang your head on this in future.

Also i dont think you need to change the settings for ODBC and SQL connections unless and until you plan to execute the package on a different server.