Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2012 Forums
 SSIS and Import/Export (2012)
 Global Editor for DTSX Files. Update 100

Author  Topic 

Analyzer
Posting Yak Master

115 Posts

Posted - 2015-04-15 : 11:04:16
Hi,

Need to modify hard coded destination strings in 100+ dtsx packages all contained within same .sln. Is there a better method than modifying each package within the UI or opening each dtsx in .txt file?

Thanks in advance

MichaelJSQL
Constraint Violating Yak Guru

252 Posts

Posted - 2015-04-15 : 11:12:56
Open the solution in VS: Check the solution , Quick replace for entire solution
Go to Top of Page

Analyzer
Posting Yak Master

115 Posts

Posted - 2015-04-16 : 03:36:04
Thanks. Didn't realise you run a find operation across all .dtsx packages in .sln. Using the Edit | Find functions did the job. Appreciate your help.

Quick Find
Quick Replace
Find in files
Replace in Files
Find Symbols
Go to Top of Page
   

- Advertisement -