Post reply

Find and Replace task in SSIS?

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

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

    😎

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

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