March 20, 2014 at 12:37 am
PFB the report after a data transfer done through wizard. The same table is for different date has been restored in respective tables. It shows less rows (check for the bold count) in the report but finally it shows the correct number of rows. Any idea on what is the reason behind this.
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].[t_results_20140225] (Success)
4831524 rows transferred
- Copying to [dbo].[t_results_20140226] (Success)
2953601 rows transferred
Messages
Information 0x402090df: Data Flow Task 1: The final commit for the data insertion in "component "Destination - t_results_20140225" (1054)" has started.
(SQL Server Import and Export Wizard)
Information 0x402090e0: Data Flow Task 1: The final commit for the data insertion in "component "Destination - t_results_20140225" (1054)" has ended.
(SQL Server Import and Export Wizard)
Information 0x402090df: Data Flow Task 1: The final commit for the data insertion in "component "Destination 1 - t_results_20140226" (2821)" has started.
(SQL Server Import and Export Wizard)
Information 0x402090e0: Data Flow Task 1: The final commit for the data insertion in "component "Destination 1 - t_results_20140226" (2821)" has ended.
(SQL Server Import and Export Wizard)
- Post-execute (Success)
Messages
Information 0x4004300b: Data Flow Task 1: "component "Destination - t_results_20140225" (1054)" wrote 4831524 rows.
(SQL Server Import and Export Wizard)
Information 0x4004300b: Data Flow Task 1: "component "Destination 1 - t_results_20140226" (2821)" wrote 4832180 rows.
(SQL Server Import and Export Wizard)
______________________________________________________________Every Problem has a Solution; Every Solution has a Problem: 🙂
March 20, 2014 at 7:31 am
This isn't very clear, at least not to me.
Are you saying that following an import using the Import Export Wizard that you get a different number of rows at the destination than what you would expect from the source?
March 20, 2014 at 10:51 pm
If you these two sentences in the report, the number of rows differ by huge margin. Actually the number of rows in second line is the correct one. My question is, though the table is same how will the number of rows differ?
- Copying to [dbo].[t_results_20140226] (Success)
2953601 rows transferred
Information 0x4004300b: Data Flow Task 1: "component "Destination 1 - t_results_20140226" (2821)" wrote 4832180 rows.
(SQL Server Import and Export Wizard)
______________________________________________________________Every Problem has a Solution; Every Solution has a Problem: 🙂
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply