This worked out fine for me.

DECLARE @SQLTEXT Table(SQLText ntext)

INSERT INTO @SQLTEXT Values('usp_CheckWeeklyResponseTeam %BD%, %ED%, %S%, %F%,%D%, %V%')

Select SQLTEXT , REPLACE(CONVERT(varchar(max),SQLTEXT),'%F%,%D%','%F%, %D%')

From @SQLTEXT

For that given string, this worked for me:

select rtrim(ltrim(replace(replace(@string,' ',''),' ','')))

Just to clarify;

you want to delete rows in the destination table before inserting new data.

True or false?

And based on what kind of conditions?

Please post the error message

For instance, if the table is being created dynamically then the user is probably using a query within a variable.

If the user used the same variable in another...

If you are using an execute sql task to dynamically create the source table then you could use that same statement in an execute sql task to create a Excel...