{"id":6285,"date":"2013-11-07T12:26:11","date_gmt":"2013-11-07T12:26:11","guid":{"rendered":"https:\/\/test.simple-talk.com\/uncategorized\/search-ssis-packages-for-tablecolumn-references\/"},"modified":"2016-07-28T10:54:14","modified_gmt":"2016-07-28T10:54:14","slug":"search-ssis-packages-for-tablecolumn-references","status":"publish","type":"post","link":"https:\/\/www.red-gate.com\/simple-talk\/blogs\/search-ssis-packages-for-tablecolumn-references\/","title":{"rendered":"Search SSIS packages for table\/column references"},"content":{"rendered":"<p>A lot of companies now use TFS or some other system and keep all their packages in a single project. This means that a copy of all the packages will end up on your local disk.<\/p>\n<p>There is major failing with SSIS that it is sometimes quite difficult to find what a package is actually doing, what it accesses and what it affects.<\/p>\n<p>This is a simple dos script which will search through all packages in a folder for a string and write the names of found packages to an output file.<\/p>\n<p>Just copy the text to a .bat file (I use aaSearch.bat) in the folder with all the package scripts Change the output filename (twice), change the find string value and run it in a dos window. It works on any text file type so you can also search store procedure scripts &#8211; but there are easier ways of doing that.<\/p>\n<p>echo. &gt; aaSearch_factSales.txt for \/f &#8220;delims=&#8221; %%a in (&#8216;dir \/B \/s *.dtsx&#8217;) do call :subr &#8220;%%a&#8221; goto:EOF<\/p>\n<p>:subr findstr &#8220;factSales&#8221; %1 if %ERRORLEVEL% NEQ 1 echo %1 &gt;&gt; aaSearch_factSales.txt goto:EOF<\/p>\n","protected":false},"excerpt":{"rendered":"<p>A lot of companies now use TFS or some other system and keep all their packages in a single project. This means that a copy of all the packages will end up on your local disk. There is major failing with SSIS that it is sometimes quite difficult to find what a package is actually&#8230;&hellip;<\/p>\n","protected":false},"author":143519,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[2],"tags":[],"coauthors":[],"class_list":["post-6285","post","type-post","status-publish","format-standard","hentry","category-blogs"],"acf":[],"_links":{"self":[{"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/posts\/6285","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/users\/143519"}],"replies":[{"embeddable":true,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/comments?post=6285"}],"version-history":[{"count":4,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/posts\/6285\/revisions"}],"predecessor-version":[{"id":25801,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/posts\/6285\/revisions\/25801"}],"wp:attachment":[{"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/media?parent=6285"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/categories?post=6285"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/tags?post=6285"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/coauthors?post=6285"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}