Post reply

How to retrieve data from systables?!

  • July 31, 2008 at 5:09 am

    #126719

    So, can I select system tables from, say, the master database? I can use an SQL statement, sure, but just clicking a table and choosing the the attributes I need is not possible?!

    Greetz,
    Hans Brouwer

  • July 31, 2008 at 7:29 am

    #851241

    Right click on the OLE DB Data Source object and select Show Advanced Editor and go to the Component Properties tab. For the OpenRowset property, type in the name of the object you want to select out from, for example, sys.all_columns.

    Once you pick that, you will get the mappings selected for you in the Column Mappings tab.

    You can then close the Advanced Editor and reopen the Data Source object and see that all of the columns are available to you to select from.

    hth

  • July 31, 2008 at 7:47 am

    #851257

    Hey, that's a nice 1, had not thought of the advanced editor.

    Tnx again.

    Greetz,
    Hans Brouwer

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

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