Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 508
  • Last Modified:

Export one table of a SQL 2005 Database

Looking to export just one table of a SQL 2005 database.  Is it possible to export the data and have import into a temp Database that I have created on a seperate instance on the same physicall server.  The destination server is a 2008 instance.
0
GSLElectric
Asked:
GSLElectric
  • 4
  • 3
1 Solution
 
GSLElectricAuthor Commented:
these are basically the steps I've followed to this point.  It seems to export successful, but no rows of data go with it.
sql-exports-steps.docx
0
 
Raja Jegan RSQL Server DBA & ArchitectCommented:
Kindly confirm

1. Whether you have records in your source table
2. You have transferred records to the correct database and verifying it over there.
0
 
GSLElectricAuthor Commented:
the source table does have records.  That has been confirmed it doesn't create a destination table in the new database and therefore there isn't any data in there as well.  Here is the report that was created when the export task was created.


The execution was successful

- Initializing Data Flow Task (Success)

- Initializing Connections (Success)

- Setting SQL Command (Success)

- Setting Source Connection (Success)

- Setting Destination Connection (Success)

- Validating (Success)

- Prepare for Execute (Success)

- Pre-execute (Success)

- Executing (Success)

- Copying to [dbo].[PRTH] (Success)
      * 0 rows transferred

      Messages
      * Information 0x402090df: Data Flow Task 1: The final commit for the data insertion in "component "Destination - PRTH" (154)" has started.
       (SQL Server Import and Export Wizard)
      
      * Information 0x402090e0: Data Flow Task 1: The final commit for the data insertion  in "component "Destination - PRTH" (154)" has ended.
       (SQL Server Import and Export Wizard)
      

- Post-execute (Success)
      Messages
      * Information 0x4004300b: Data Flow Task 1: "component "Destination - PRTH" (154)" wrote 0 rows.
       (SQL Server Import and Export Wizard)
      
0
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
Raja Jegan RSQL Server DBA & ArchitectCommented:
Can you try transferring records into a new temp table say test in that particular database to see whether it works or not..
0
 
GSLElectricAuthor Commented:
do you follow those same steps in order to do that?
0
 
Raja Jegan RSQL Server DBA & ArchitectCommented:
Able to successfully move records in my system using the above steps..
That's why asking you to ensure that things are followed correctly.
0
 
GSLElectricAuthor Commented:
It was a security issue.  I had to use the SA account to make it work.
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 4
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now