Post reply

How to export data from multiple table using search/matching pattern in DTS?

  • June 2, 2010 at 5:08 am

    #145159

    Hello,

    I need to export table data using DTS. The situation is I have around 15000 tables and I need data from few tables which have a matching pattern like - APP*.

    I know, I can scroll down in the table selection window and click on the desired tables but this is very time consuming.

    I would like to get records like,

    select * from App*

    Please let me know if I am not clear. I can provide you more information on this .

    Thanks,

    Sanjeev.

  • June 2, 2010 at 6:41 am

    #1175247

    You can use SQL query: "select name from sysobjects where xtype='U' and name like 'App%' " as your first step in DTS package, pass table names to the variable and then use "for each loop" to export data. Not sure how you are going to handle different columns in tables though.

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

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