Sounds like the connectionstring is stored in package configuration. You will need to change the package configuration not the package itself. Look on the Package Configurations... option from the...

I too have had problem with converting strings to datetime fields. After trying various different methods I now use a VB transform script and the DateTime.ParseExact .Net method. It allows...

More than likely this is to do with the ProtectionLevel property of a SSIS package.

If set to DontSaveSensitive then password are not saved within SSIS packages.

Instead use a Package Configuration...

Create a variable called DateAsString as String

Set the Properties of the Variable EvaluateAsExpression to true and ReadOnly as True. Set the Expression to:

RIGHT("0" + (DT_STR,4,1252)DATEPART( "dd" , @[System::StartTime]) , 2)...

I too have had several problems with installing SP1 for 2005.

On some workstations and servers the service pack failed to install the first time. But did install on second or even...

The following will return 1 or 0 when R.Number_of_records = 0, which is what I think you are trying to do:

((SIGN(R.Number_of_records) - 1) * -1)