Is it possible to change the connectionstring of package inside SQL server in management studio?

you can right click on the package in SSMS, then select "run package" then in the "execute package utility" window, go to "connection manager" tab, and change connection string as you want.http://www.rad.pasfu.com

But that setting doesnt keep (save) the changes...

If you want to keep changes for all times, use PACKAGE CONFIGURATION, and then connection string will use configuration values at all times. for more information about package configuration look here: http://www.mssqltips.com/tip.asp?tip=1405 http://msdn.microsoft.com/en-us/library/cc895212.aspx http://www.sqlservercentral.com/articles/Integration+Services+%28SSIS%29/66500/http://www.rad.pasfu.com