Automated Export all tables with a where clause?

• aFatGirl

  Valued Member

  Points: 51

  More actions

  May 9, 2002 at 1:28 pm

  #64077

  I have a DB with about 30 tables in it with a field CUSTOMER_ID in each of the tables. I want a way that I can automatically export each of these tables for a specific customer. Also as we continue development we will be adding several tables with each release.

  I was thinking about a DTS package but not sure if I can pass a parameter (CUSTOMER_ID) to a package. And if I do use a DTS package what about when I add more tables? BCP won’t return field names. Any suggestions?

• Steve Jones - SSC Editor

  SSC Guru

  Points: 738693

  More actions

  May 9, 2002 at 4:33 pm

  #428842

  You can use a dynamic properties task in DTS if this is SQL 2000 to change the package based on some value.

  Steve Jones

  steve@dkranch.net