- C# Scripts
- DWH INTERVIEW QUESTIONS
- MS Dynamics AX 2012 R2 Video Tutorial
- Project / Work Support
- SQL SERVER DBA INTERVIEW QUESTIONS
- SQL SERVER DBA Video Tutorial
- SQL Server / TSQL Tutorial
- SQL Server 2016
- SQL Server Scripts
- SSIS INTERVIEW QUESTIONS
- SSIS Video Tutorial
- SSRS INTERVIEW QUESTIONS
- SSRS Video Tutorial
- TSQL INTERVIEW QUESTIONS
- Team Foundation Server 2013 Video Tutorial
- Team Foundation Server 2015 Video Tutorial
- Windows 10
- Windows Server 2012 R2 Installation Videos
SSIS - How To Find and Replace Text In SSIS Package/s?
A developer from our team stopped by and he asked me that he has used a Stored Procedure multiple times in a SSIS Package and want to replace with new name. I asked him that why do you want to change the name of Stored Procedure. His answer was that he did not follow the naming convention or company’s standards for TSQL Object name and now he realized that he need to change the Stored Procedure name in Database as well in SSIS Package.
Once solution can be go to the SSIS Package and open each of the Execute SQL Task or any other tasks where you have used the Stored Procedure. This can be lengthy and tiring process. How about finding the Stored Procedure and just replace it?
Open the SSIS Package in BIDS, Right Click on SSIS Package and Click on View Code
Fig 1: SSIS View Code
You will see the SSIS Package opened as XML file. Press Ctrl+F or Ctrl+H to find and replace. Put the text that you want to find and provide text with which you want to replace as shown below
You will have the option to Replace the founded text in entire solution that may contain more than one SSIS Package. In my case I only want to replace in Current Document.
Once done, close the file and save the SSIS Package or entire solution with all SSIS Packages.