Post reply

How to configure OLE DB to use dynamic connection?

  • September 26, 2012 at 10:19 am

    #282193

    Good afternoon,

    Using the following excellent site as my inspiration http://sql-ution.com/ 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.

    ---------------------------------------------------------

    It takes a minimal capacity for rational thought to see that the corporate 'free press' is a structurally irrational and biased, and extremely violent, system of elite propaganda.
    David Edwards - Media lens[/url]

    Society has varying and conflicting interests; what is called objectivity is the disguise of one of these interests - that of neutrality. But neutrality is a fiction in an unneutral world. There are victims, there are executioners, and there are bystanders... and the 'objectivity' of the bystander calls for inaction while other heads fall.
    Howard Zinn

  • October 1, 2012 at 9:55 am

    #1544039

    This issue has now been resolved.

    ---------------------------------------------------------

    It takes a minimal capacity for rational thought to see that the corporate 'free press' is a structurally irrational and biased, and extremely violent, system of elite propaganda.
    David Edwards - Media lens[/url]

    Society has varying and conflicting interests; what is called objectivity is the disguise of one of these interests - that of neutrality. But neutrality is a fiction in an unneutral world. There are victims, there are executioners, and there are bystanders... and the 'objectivity' of the bystander calls for inaction while other heads fall.
    Howard Zinn

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply