Please start any new threads on our new site at 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 

Posting Yak Master

115 Posts

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

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

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

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 -