Hi,

I was able to execute the following in Management studio successfully but was unable to replicate the results when using BIDS.

Update dbo.mydatabase

Set stage = REPLACE(Stage,'Closed Won','Awarded')

I tried the table...

Thank you and all who responded. I had to break away for a lenghty meeting and will being trying the solutions in a bit. I'll report back the results.

Hi,

I was able to get it to run with out error using calvo's statement and also Mack's statement. The only issue is that the value of Closed Won is not...

Hi Mack,

I attached a screen shot from SSIS which shows the statement. Stage is the correc col. name.

Hi Mack,

Thank you for the reponse. I used the statement and it returned the following.

[Execute SQL Task] Error: Executing the query "REPLACE(Stage,'Closed Won','Awarded')" failed with the following error: "Incorrect syntax...