Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
leahsmart
Posting Yak Master
133 Posts |
 Posted - 2006-12-13 : 06:19:15
|
Hello,I am trying to export a table of data from a 2000 database into a 2005 database. I am using the SQL Server Management Studio to do this. In my export I have told it to ignore certain fields but I am getting the below error. All the fields listed below are ones I have told the export to ignore.Does anyone have any idea what this is on about and how to fix it?ThanksLeahOperation stopped...- Initializing Data Flow Task (Success)- Initializing Connections (Success)- Setting SQL Command (Success)- Setting Source Connection (Success)- Setting Destination Connection (Success)- Validating (Error) Messages * Warning 0x80047076: Data Flow Task: The output column "CompanyNotes" (50) on output "OLE DB Source Output" (11) and component "Source - tblCompany" (1) is not subsequently used in the Data Flow task. Removing this unused output column can increase Data Flow task performance. (SQL Server Import and Export Wizard) * Warning 0x80047076: Data Flow Task: The output column "CompanyImportRef" (71) on output "OLE DB Source Output" (11) and component "Source - tblCompany" (1) is not subsequently used in the Data Flow task. Removing this unused output column can increase Data Flow task performance. (SQL Server Import and Export Wizard) * Warning 0x80047076: Data Flow Task: The output column "CompanyExportRef" (74) on output "OLE DB Source Output" (11) and component "Source - tblCompany" (1) is not subsequently used in the Data Flow task. Removing this unused output column can increase Data Flow task performance. (SQL Server Import and Export Wizard) * Warning 0x80047076: Data Flow Task: The output column "Ali" (146) on output "OLE DB Source Output" (11) and component "Source - tblCompany" (1) is not subsequently used in the Data Flow task. Removing this unused output column can increase Data Flow task performance. (SQL Server Import and Export Wizard) * Warning 0x80047076: Data Flow Task: The output column "CompanyText1" (149) on output "OLE DB Source Output" (11) and component "Source - tblCompany" (1) is not subsequently used in the Data Flow task. Removing this unused output column can increase Data Flow task performance. (SQL Server Import and Export Wizard) * Warning 0x80047076: Data Flow Task: The output column "ClubReference" (197) on output "OLE DB Source Output" (11) and component "Source - tblCompany" (1) is not subsequently used in the Data Flow task. Removing this unused output column can increase Data Flow task performance. (SQL Server Import and Export Wizard) * Warning 0x80047076: Data Flow Task: The output column "ClubEmail" (200) on output "OLE DB Source Output" (11) and component "Source - tblCompany" (1) is not subsequently used in the Data Flow task. Removing this unused output column can increase Data Flow task performance. (SQL Server Import and Export Wizard) * Warning 0x80047076: Data Flow Task: The output column "ClubJoined" (203) on output "OLE DB Source Output" (11) and component "Source - tblCompany" (1) is not subsequently used in the Data Flow task. Removing this unused output column can increase Data Flow task performance. (SQL Server Import and Export Wizard) * Warning 0x80047076: Data Flow Task: The output column "ClubLeft" (206) on output "OLE DB Source Output" (11) and component "Source - tblCompany" (1) is not subsequently used in the Data Flow task. Removing this unused output column can increase Data Flow task performance. (SQL Server Import and Export Wizard) * Warning 0x80047076: Data Flow Task: The output column "ClubID" (209) on output "OLE DB Source Output" (11) and component "Source - tblCompany" (1) is not subsequently used in the Data Flow task. Removing this unused output column can increase Data Flow task performance. (SQL Server Import and Export Wizard) * Warning 0x80047076: Data Flow Task: The output column "ClubIDAsText" (212) on output "OLE DB Source Output" (11) and component "Source - tblCompany" (1) is not subsequently used in the Data Flow task. Removing this unused output column can increase Data Flow task performance. (SQL Server Import and Export Wizard) * Warning 0x80047076: Data Flow Task: The output column "ClubLogin" (215) on output "OLE DB Source Output" (11) and component "Source - tblCompany" (1) is not subsequently used in the Data Flow task. Removing this unused output column can increase Data Flow task performance. (SQL Server Import and Export Wizard) * Warning 0x80047076: Data Flow Task: The output column "PrivacyOption" (221) on output "OLE DB Source Output" (11) and component "Source - tblCompany" (1) is not subsequently used in the Data Flow task. Removing this unused output column can increase Data Flow task performance. (SQL Server Import and Export Wizard) * Error 0xc002f210: Preparation SQL Task: Executing the query "TRUNCATE TABLE [ec2007].[dbo].[tblCompany] " failed with the following error: "Cannot truncate table 'ec2007.dbo.tblCompany' because it is being referenced by a FOREIGN KEY constraint.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly. (SQL Server Import and Export Wizard) - Prepare for Execute (Stopped)- Pre-execute (Stopped)- Executing (Success)- Copying to [ec2007].[dbo].[tblCompany] (Stopped)- Post-execute (Stopped)- Cleanup (Stopped) |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2006-12-13 : 07:44:14
|
| You are trying to truncate the destination table then add the data probably.The table has a foreign key referencing it so the truncate is failing.Remove the foreign key for the transfer or do a delete instead.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
cycledude
Starting Member
9 Posts |
Posted - 2008-03-08 : 16:52:15
|
| I encountered the same "Error 0xc002f210: Preparation SQL Task" error when attempting to copy data from a SQL Server 2000 database to a SQL Server 2005 database. The data imported successfully using the following steps:1) Truncated each destination table individually using TRUNCATE TABLE (tablename).2) Used the SQL Import/Export Wizard to populate each destination table individually. There is also an option in the wizard to clear destination tables, but I didn't use it.3) On the "Source Tables and Views screen" of the Wizard, clicked the "Edit Mappings" button and selected "Enable Identity Insert". |
|
|
|
|
|
|
SQL 2005 Import/Export Issues