June 10, 2010 at 5:23 pm
We've got several SSIS packages and some DTS packages that haven't been converted to SSIS packages yet. We've got someone who has been with the company for a long time and is leaving. I'm sure there are many instances where this person's username and password is embedded in the code to authenticate on our i5 and other ODBC connections. Is there some easy fast way to see every instance of this person's username so that can be changed to something else?
June 10, 2010 at 5:38 pm
Do a simple text search on the DTSXs. There really is no other way for the SSIS packages. DTS and other objects, dunno.
Todd McDermid - SQL Server MVP, MCSD.Net, MCTS (SQL08BI)
Find great SSIS extensions - most are open source - at SSIS Community Tasks and Components[/url]
Are you doing Data Warehouse ETL with SSIS? Don't use the slow SCD Wizard, use the Kimball Method SCD component instead.
June 10, 2010 at 6:00 pm
Thanks, that's a good idea for the SSIS packages. Any ideas out there on how to handle this with the DTS packages?
June 11, 2010 at 9:35 am
You can save a DTS package as a Visual Basic file by opening it with DTS Designer, expand Package, Save As..., make the location "Visual Basic File". You can then edit the saved VB file and search for the login.
Greg
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply