How to configure OLE DB to use dynamic connection?

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » SQL Server 2005 Integration Services » How to configure OLE DB to use dynamic...

How to configure OLE DB to use dynamic connection?

Rate Topic

Display Mode

Topic Options

Author

Message

Abu Dina

Posted Wednesday, September 26, 2012 10:19 AM

SSC-Addicted

Group: General Forum Members
Last Login: Yesterday @ 10:34 AM
Points: 494, Visits: 2,158

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.

-----------------------------------
http://www.SQL4n00bs.com

Post #1364817

Abu Dina

Posted Monday, October 01, 2012 9:55 AM

SSC-Addicted

Group: General Forum Members
Last Login: Yesterday @ 10:34 AM
Points: 494, Visits: 2,158

This issue has now been resolved.

-----------------------------------
http://www.SQL4n00bs.com

Post #1366638

« Prev Topic | Next Topic »

Permissions