I've created variables for all the various FTP settings my FTP script needs to perform. I switched to variables so I wouldn't have to mess with the script each time something changed. My question I suppose I must open up the package project each time to change any variable's value correct. I'm used to app.config files where these changes can be made in a text file. Am i missing something? TIA Harry

You should use package configuration to change the value of a variable.Please mark the post as answered if it answers your question | My SSIS Blog: http://microsoft-ssis.blogspot.com

I'm working in VS2005 which doesn't have this same Configuration Manager or am I missing it. SSIS menu item only has one choice - "Work Offline"

A good "how to" on the SSIS configuration for SQL Server 2005: http://www.sql-server-performance.com/articles/dba/package_configuration_2005_p1.aspxArthur My Blog

I'm working in VS2005 which doesn't have this same Configuration Manager or am I missing it. SSIS menu item only has one choice - "Work Offline" it has nearly the same Configuration Manager as 2008. Have you opened your package? The configuration is per package. Please mark the post as answered if it answers your question | My SSIS Blog: http://microsoft-ssis.blogspot.com

"In SQL Server 2005, you have an option called Package Configurations under the SSIS menu option to allow database developers to store package configurations outside the SSIS packages." I swear I'm stumped as to how to get to the SSIS menu in SQL Server 2005. Is this somewhere in SQL Server Management Studio or off the main file directory for SQL Server 2005? I've created the manifest file but when I double click it it says I need SQL Server 2008.....argh!! How do I get to the Package Configurations section??

"In SQL Server 2005, you have an option called Package Configurations under the SSIS menu option to allow database developers to store package configurations outside the SSIS packages." I swear I'm stumped as to how to get to the SSIS menu in SQL Server 2005. Is this somewhere in SQL Server Management Studio or off the main file directory for SQL Server 2005? I've created the manifest file but when I double click it it says I need SQL Server 2008.....argh!! How do I get to the Package Configurations section?? It's in Visual Studio/BIDS, but you have to open your package [View Designer] and then select something in your package. If you don't you will only see Work Offline and Debug Process Reporting.Please mark the post as answered if it answers your question | My SSIS Blog: http://microsoft-ssis.blogspot.com

No, it is in BIDS (aka Visual Studio shell) - Business Intelligence Development Studio at package design phase; this item is normally found under Start -> Microsoft SQL Server 2008 or 2005 Not sure why you get this error, any steps to reproduce? Arthur My Blog

I had the package opened in the designer but had to actually click inside the package before the menu expanded. Thanks http://www.sql-server-performance.com/articles/dba/package_configuration_2005_p1.aspx would be helpful other than the fact mine looks like none of these UIs I just want to be able to set my User Variables easily. If I have to open up the package each time I can just set them in the editor. Don't see how to really set them externally ie file based.

I had the package opened in the designer but had to actually click inside the package before the menu expanded. Thanks http://www.sql-server-performance.com/articles/dba/package_configuration_2005_p1.aspx would be helpful other than the fact mine looks like none of these UIs I just want to be able to set my User Variables easily. If I have to open up the package each time I can just set them in the editor. Don't see how to really set them externally ie file based. Thanks Joost - thought that was the answer but I still don't see where these variables in the package can display and set different values from outside the package.

I had the package opened in the designer but had to actually click inside the package before the menu expanded. Thanks http://www.sql-server-performance.com/articles/dba/package_configuration_2005_p1.aspx would be helpful other than the fact mine looks like none of these UIs I just want to be able to set my User Variables easily. If I have to open up the package each time I can just set them in the editor. Don't see how to really set them externally ie file based. Thanks Joost - thought that was the answer but I still don't see where these variables in the package can display and set different values from outside the package.