Find and Replace task in SSIS?

  • 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.

  • 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.

    😎

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply