Results 1 to 2 of 2
  1. #1
    Join Date
    May 2004

    Unanswered: Virtual to Static Table

    Please forgive this elementary question. I have database which has a view that produces the desired records and fields from multiple tables. As I understand it a view is a Virtual Table. My problem is I need to export these results periodically to deliver to a customer. I am running this database on SQL Server 2000 if I right click on a table I have the option to dts the data to a text file but when I right click on the view I do not have this option. How can I make this virtual table an actual table. PLEASE Help Thank You, Ed

  2. #2
    Join Date
    Apr 2004
    NJ United States
    If you have a select statement that you use in your view, then create a dts package and use the same select statement.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts