August 25, 2008 at 10:02 am
Hi,
Here is my scenario:
I have a table which stores a connection string "Data Source=servername;Initial Catalog=database;Integrated Security=True" and a table name "table". I want to be able to simply pull information from the data source and table on a dynamic basis. OpenRowSet poses some security concerns, I believe. What is the best way to accomplish this? Thanks!
August 25, 2008 at 11:00 am
What environment do you wish to achieve this from? I'm reasonably certain that this would be fairly easy from within the VBA code inside of MS Access or from an ASP webpage, but what's the objective for the data that gets retrieved? Since one could not necessarily know what databases or tables are being retrieved, it might be hard to decide what to do with any given data, much less put any structure around it...
Steve
(aka smunson)
:):):)
Steve (aka sgmunson) 🙂 🙂 🙂
Rent Servers for Income (picks and shovels strategy)
August 25, 2008 at 12:01 pm
I have a SQL Server IS package which reads table data from a static table and creates Active Directory accounts. I want the same process (which is run as a SQL timer) to read data from another table which lists other possible "views" and their column mappings for AD and use the same algorithm to create the account. The table stores the data connection string and view / table name. Another table maps the said data source to the correct mapping in AD. Thanks!
August 25, 2008 at 12:05 pm
I would probably use a SSIS package and use a script task to read information from your table to configure the connection for reading the data.
You can loop thru this logic until you've read every value from your table, assuming that's what you want to do.
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply