Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Importing with sucess but no row
Message
From
18/06/2006 20:52:55
 
 
To
All
General information
Forum:
Microsoft SQL Server
Category:
Import/Export
Title:
Importing with sucess but no row
Miscellaneous
Thread ID:
01129873
Message ID:
01129873
Views:
87
This one is interesting. I guess there must be a simple reason for that. Here is the result of the import I just did:
- Executing (Success)

- Copying to [Direct Martial Arts].[dbo].[style] (Success)
	* 195 rows transferred

- Copying to [Direct Martial Arts].[dbo].[stylecategory] (Success)
	* 99 rows transferred

- Copying to [Direct Martial Arts].[dbo].[styledefinition] (Success)
	* 808 rows transferred

	Messages
	* Information 0x402090df: Data Flow Task: The final commit for the data insertion has started.
	 (SQL Server Import and Export Wizard)
	
	* Information 0x402090e0: Data Flow Task: The final commit for the data insertion has ended.
	 (SQL Server Import and Export Wizard)
	
	* Information 0x402090df: Data Flow Task: The final commit for the data insertion has started.
	 (SQL Server Import and Export Wizard)
	
	* Information 0x402090e0: Data Flow Task: The final commit for the data insertion has ended.
	 (SQL Server Import and Export Wizard)
	
	* Information 0x402090df: Data Flow Task: The final commit for the data insertion has started.
	 (SQL Server Import and Export Wizard)
	
	* Information 0x402090e0: Data Flow Task: The final commit for the data insertion has ended.
	 (SQL Server Import and Export Wizard)
	

- Post-execute (Success)

- Cleanup (Success)
	Messages
	* Information 0x4004300b: Data Flow Task: "component "Destination - style" (82)" wrote 195 rows.
	 (SQL Server Import and Export Wizard)
	
	* Information 0x4004300b: Data Flow Task: "component "Destination 1 - stylecategory" (180)" wrote 99 rows.
	 (SQL Server Import and Export Wizard)
	
	* Information 0x4004300b: Data Flow Task: "component "Destination 2 - styledefinition" (254)" wrote 808 rows.
	 (SQL Server Import and Export Wizard)
So, as you can see, three tables have been imported successfully. However, when I go in the table and open it, there is no row in Style, 99 rows in StyleCategory but the structure is not the structure from the Visual FoxPro table, and everything ok for StyleDefinition. So, I wonder where are all those rows of table Style and why the structure of StyleCategory is completely mixed up.
Michel Fournier
Level Extreme Inc.
Designer, architect, owner of the Level Extreme Platform
Subscribe to the site at https://www.levelextreme.com/Home/DataEntry?Activator=55&NoStore=303
Subscription benefits https://www.levelextreme.com/Home/ViewPage?Activator=7&ID=52
Next
Reply
Map
View

Click here to load this message in the networking platform