Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

How to configure OLE DB to use dynamic connection? Expand / Collapse
Author
Message
Posted Wednesday, September 26, 2012 10:19 AM


Say Hey Kid

Say Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey Kid

Group: General Forum Members
Last Login: Monday, October 13, 2014 4:54 AM
Points: 708, Visits: 3,290
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

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
Post #1364817
Posted Monday, October 1, 2012 9:55 AM


Say Hey Kid

Say Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey Kid

Group: General Forum Members
Last Login: Monday, October 13, 2014 4:54 AM
Points: 708, Visits: 3,290
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

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
Post #1366638
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse