InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comWed, 19 Jun 2013 14:57:39 GMT20http://www.sqlservercentral.com/Forums/Topic1364817-148-1.aspxThis issue has now been resolved.Mon, 01 Oct 2012 09:55:08 GMTAbu Dinahttp://www.sqlservercentral.com/Forums/Topic1364817-148-1.aspxGood afternoon,Using the following excellent site as my inspiration [url]http://sql-ution.com/[/url] to build my own DBA repository from scratch.Progress so far:See below:1) This gets list of servers from a SQLServers table I have in my DBA Repository database.2) In my Foreach SQL Server loop I have a task that will attempt to connect to the server. If the package can't establish connection then an entry is added to the log table.3) Don't worry about this.. still WIP!4) This just displays a box with the server name - not important.5) Now this is where it gets interesting. As I'm looping through my servers, I want to get information about each server and then store it in my DBA repository. The problem is when I go to define my OLD DB source (see below). SSIS will not allow me to select the Dynamic Connection!Any ideas?!Thanks.[img]http://s9.postimage.org/w83hip5lb/SSISProblem.jpg[/img][img]http://s12.postimage.org/zeydz59gt/OLEDBSOURCE.jpg[/img]Wed, 26 Sep 2012 10:19:11 GMTAbu Dina