Post reply

schema restrictions

  • April 19, 2010 at 9:35 am

    #139684

    Hi All,

    I'm using For Each ADO.NET schema row set enumerator to loop through the tables in a database. But i get the system tables, constraints etc. i need only the table names.

    how to use the set restrictions 'Text'. I feel by doing this i can achieve the above

    any help is highly appreciated.

    thanks

    regards

    ami

  • April 19, 2010 at 10:08 am

    #1153950

    You could use an EXEC sql task to fill a variable of type Object and use the "Foreach ADO Enumerator" instead. Then you could control what ends up in the F-E-L..

    CEWII

  • April 19, 2010 at 11:02 am

    #1154002

    Elliott,

    Thanks for an immediate reply. But I would like to know how best we can make use of ADO.NET schema row set enumerator

    regards

    ami

  • April 19, 2010 at 12:22 pm

    #1154075

    Sorry, I can't help you there.

    I don't use that option.

    CEWII

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

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