Find and Replace task in SSIS?

• hbk_sql

  SSC-Addicted

  Points: 425

  More actions

  April 4, 2015 at 9:47 am

  #302733

  Hi,

  We have a SSIS package to deploy script (install SP’s) to SQL database and apply permissions to users on newly created SP’s. Basically SSIS package first moves the script to deployment folder and then apply script to database and apply permissions. It was automated and running fine.

  But now we have a requirement to change the script before deploy to target database. Like change the email address in script based on environment.

  Is there any feature in SSIS ? so that I can find and replace in script before move to sql execute task?

  Thanks.

• Eirikur Eiriksson

  SSC Guru

  Points: 182947

  More actions

  April 4, 2015 at 10:44 am

  #1788749

  hbk_sql (4/4/2015)

  ---

  Hi,

  We have a SSIS package to deploy script (install SP’s) to SQL database and apply permissions to users on newly created SP’s. Basically SSIS package first moves the script to deployment folder and then apply script to database and apply permissions. It was automated and running fine.

  But now we have a requirement to change the script before deploy to target database. Like change the email address in script based on environment.

  Is there any feature in SSIS ? so that I can find and replace in script before move to sql execute task?

  Thanks.

  Quick suggestion, use REPLACE (SSIS Expression) in a script task.