Here is the message I get using the import wizard.
Its a giant file, I can only open it in ultra edit.
All the fields have been created using varchar(255)
Operation stopped…
– Initializing Data Flow Task (Success)
– Initializing Connections (Success)
– Setting SQL Command (Success)
– Setting Source Connection (Success)
– Setting Destination Connection (Success)
– Validating (Warning)
Messages
* Warning 0x80047076: Data Flow Task: The output column “Column 0” (10) on output “Flat File Source Output” (2) and component “Source – Skinner-VOTERLIST-12-MAR-07_TXT” (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 “Column 1” (14) on output “Flat File Source Output” (2) and component “Source – Skinner-VOTERLIST-12-MAR-07_TXT” (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 “Column 2” (18) on output “Flat File Source Output” (2) and component “Source – Skinner-VOTERLIST-12-MAR-07_TXT” (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 “Column 3” (22) on output “Flat File Source Output” (2) and component “Source – Skinner-VOTERLIST-12-MAR-07_TXT” (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 “Column 4” (26) on output “Flat File Source Output” (2) and component “Source – Skinner-VOTERLIST-12-MAR-07_TXT” (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 “Column 5” (30) on output “Flat File Source Output” (2) and component “Source – Skinner-VOTERLIST-12-MAR-07_TXT” (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 “Column 6” (34) on output “Flat File Source Output” (2) and component “Source – Skinner-VOTERLIST-12-MAR-07_TXT” (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 “Column 7” (38) on output “Flat File Source Output” (2) and component “Source – Skinner-VOTERLIST-12-MAR-07_TXT” (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 “Column 8” (42) on output “Flat File Source Output” (2) and component “Source – Skinner-VOTERLIST-12-MAR-07_TXT” (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 “Column 9” (46) on output “Flat File Source Output” (2) and component “Source – Skinner-VOTERLIST-12-MAR-07_TXT” (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 “Column 10” (50) on output “Flat File Source Output” (2) and component “Source – Skinner-VOTERLIST-12-MAR-07_TXT” (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 “Column 11” (54) on output “Flat File Source Output” (2) and component “Source – Skinner-VOTERLIST-12-MAR-07_TXT” (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 “Column 12” (58) on output “Flat File Source Output” (2) and component “Source – Skinner-VOTERLIST-12-MAR-07_TXT” (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 “Column 13” (62) on output “Flat File Source Output” (2) and component “Source – Skinner-VOTERLIST-12-MAR-07_TXT” (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 “Column 14” (66) on output “Flat File Source Output” (2) and component “Source – Skinner-VOTERLIST-12-MAR-07_TXT” (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 “Column 15” (70) on output “Flat File Source Output” (2) and component “Source – Skinner-VOTERLIST-12-MAR-07_TXT” (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 “Column 16” (74) on output “Flat File Source Output” (2) and component “Source – Skinner-VOTERLIST-12-MAR-07_TXT” (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 “Column 17” (78) on output “Flat File Source Output” (2) and component “Source – Skinner-VOTERLIST-12-MAR-07_TXT” (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 “Column 18” (82) on output “Flat File Source Output” (2) and component “Source – Skinner-VOTERLIST-12-MAR-07_TXT” (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 “Column 19” (86) on output “Flat File Source Output” (2) and component “Source – Skinner-VOTERLIST-12-MAR-07_TXT” (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 “Column 20” (90) on output “Flat File Source Output” (2) and component “Source – Skinner-VOTERLIST-12-MAR-07_TXT” (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 “Column 21” (94) on output “Flat File Source Output” (2) and component “Source – Skinner-VOTERLIST-12-MAR-07_TXT” (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 “Column 22” (98) on output “Flat File Source Output” (2) and component “Source – Skinner-VOTERLIST-12-MAR-07_TXT” (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 “Column 23” (102) on output “Flat File Source Output” (2) and component “Source – Skinner-VOTERLIST-12-MAR-07_TXT” (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 “Column 24” (106) on output “Flat File Source Output” (2) and component “Source – Skinner-VOTERLIST-12-MAR-07_TXT” (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 “Column 25” (110) on output “Flat File Source Output” (2) and component “Source – Skinner-VOTERLIST-12-MAR-07_TXT” (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 “Column 26” (114) on output “Flat File Source Output” (2) and component “Source – Skinner-VOTERLIST-12-MAR-07_TXT” (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 “Column 27” (118) on output “Flat File Source Output” (2) and component “Source – Skinner-VOTERLIST-12-MAR-07_TXT” (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 “Column 28” (122) on output “Flat File Source Output” (2) and component “Source – Skinner-VOTERLIST-12-MAR-07_TXT” (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 “Column 29” (126) on output “Flat File Source Output” (2) and component “Source – Skinner-VOTERLIST-12-MAR-07_TXT” (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 “Column 30” (130) on output “Flat File Source Output” (2) and component “Source – Skinner-VOTERLIST-12-MAR-07_TXT” (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 “Column 31” (134) on output “Flat File Source Output” (2) and component “Source – Skinner-VOTERLIST-12-MAR-07_TXT” (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 “Column 32” (138) on output “Flat File Source Output” (2) and component “Source – Skinner-VOTERLIST-12-MAR-07_TXT” (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 “Column 33” (142) on output “Flat File Source Output” (2) and component “Source – Skinner-VOTERLIST-12-MAR-07_TXT” (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 “Column 34” (146) on output “Flat File Source Output” (2) and component “Source – Skinner-VOTERLIST-12-MAR-07_TXT” (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 “Column 35” (150) on output “Flat File Source Output” (2) and component “Source – Skinner-VOTERLIST-12-MAR-07_TXT” (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 “Column 36” (154) on output “Flat File Source Output” (2) and component “Source – Skinner-VOTERLIST-12-MAR-07_TXT” (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 “Column 37” (158) on output “Flat File Source Output” (2) and component “Source – Skinner-VOTERLIST-12-MAR-07_TXT” (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 “Column 38” (162) on output “Flat File Source Output” (2) and component “Source – Skinner-VOTERLIST-12-MAR-07_TXT” (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 “Column 39” (166) on output “Flat File Source Output” (2) and component “Source – Skinner-VOTERLIST-12-MAR-07_TXT” (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 “Column 40” (170) on output “Flat File Source Output” (2) and component “Source – Skinner-VOTERLIST-12-MAR-07_TXT” (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 “Column 41” (174) on output “Flat File Source Output” (2) and component “Source – Skinner-VOTERLIST-12-MAR-07_TXT” (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 “Column 42” (178) on output “Flat File Source Output” (2) and component “Source – Skinner-VOTERLIST-12-MAR-07_TXT” (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 “Column 43” (182) on output “Flat File Source Output” (2) and component “Source – Skinner-VOTERLIST-12-MAR-07_TXT” (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 “Column 0” (10) on output “Flat File Source Output” (2) and component “Source – Skinner-VOTERLIST-12-MAR-07_TXT” (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 “Column 1” (14) on output “Flat File Source Output” (2) and component “Source – Skinner-VOTERLIST-12-MAR-07_TXT” (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 “Column 2” (18) on output “Flat File Source Output” (2) and component “Source – Skinner-VOTERLIST-12-MAR-07_TXT” (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 “Column 3” (22) on output “Flat File Source Output” (2) and component “Source – Skinner-VOTERLIST-12-MAR-07_TXT” (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 “Column 4” (26) on output “Flat File Source Output” (2) and component “Source – Skinner-VOTERLIST-12-MAR-07_TXT” (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 “Column 5” (30) on output “Flat File Source Output” (2) and component “Source – Skinner-VOTERLIST-12-MAR-07_TXT” (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 “Column 6” (34) on output “Flat File Source Output” (2) and component “Source – Skinner-VOTERLIST-12-MAR-07_TXT” (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 “Column 7” (38) on output “Flat File Source Output” (2) and component “Source – Skinner-VOTERLIST-12-MAR-07_TXT” (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 “Column 8” (42) on output “Flat File Source Output” (2) and component “Source – Skinner-VOTERLIST-12-MAR-07_TXT” (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 “Column 9” (46) on output “Flat File Source Output” (2) and component “Source – Skinner-VOTERLIST-12-MAR-07_TXT” (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 “Column 10” (50) on output “Flat File Source Output” (2) and component “Source – Skinner-VOTERLIST-12-MAR-07_TXT” (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 “Column 11” (54) on output “Flat File Source Output” (2) and component “Source – Skinner-VOTERLIST-12-MAR-07_TXT” (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 “Column 12” (58) on output “Flat File Source Output” (2) and component “Source – Skinner-VOTERLIST-12-MAR-07_TXT” (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 “Column 13” (62) on output “Flat File Source Output” (2) and component “Source – Skinner-VOTERLIST-12-MAR-07_TXT” (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 “Column 14” (66) on output “Flat File Source Output” (2) and component “Source – Skinner-VOTERLIST-12-MAR-07_TXT” (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 “Column 15” (70) on output “Flat File Source Output” (2) and component “Source – Skinner-VOTERLIST-12-MAR-07_TXT” (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 “Column 16” (74) on output “Flat File Source Output” (2) and component “Source – Skinner-VOTERLIST-12-MAR-07_TXT” (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 “Column 17” (78) on output “Flat File Source Output” (2) and component “Source – Skinner-VOTERLIST-12-MAR-07_TXT” (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 “Column 18” (82) on output “Flat File Source Output” (2) and component “Source – Skinner-VOTERLIST-12-MAR-07_TXT” (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 “Column 19” (86) on output “Flat File Source Output” (2) and component “Source – Skinner-VOTERLIST-12-MAR-07_TXT” (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 “Column 20” (90) on output “Flat File Source Output” (2) and component “Source – Skinner-VOTERLIST-12-MAR-07_TXT” (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 “Column 21” (94) on output “Flat File Source Output” (2) and component “Source – Skinner-VOTERLIST-12-MAR-07_TXT” (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 “Column 22” (98) on output “Flat File Source Output” (2) and component “Source – Skinner-VOTERLIST-12-MAR-07_TXT” (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 “Column 23” (102) on output “Flat File Source Output” (2) and component “Source – Skinner-VOTERLIST-12-MAR-07_TXT” (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 “Column 24” (106) on output “Flat File Source Output” (2) and component “Source – Skinner-VOTERLIST-12-MAR-07_TXT” (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 “Column 25” (110) on output “Flat File Source Output” (2) and component “Source – Skinner-VOTERLIST-12-MAR-07_TXT” (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 “Column 26” (114) on output “Flat File Source Output” (2) and component “Source – Skinner-VOTERLIST-12-MAR-07_TXT” (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 “Column 27” (118) on output “Flat File Source Output” (2) and component “Source – Skinner-VOTERLIST-12-MAR-07_TXT” (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 “Column 28” (122) on output “Flat File Source Output” (2) and component “Source – Skinner-VOTERLIST-12-MAR-07_TXT” (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 “Column 29” (126) on output “Flat File Source Output” (2) and component “Source – Skinner-VOTERLIST-12-MAR-07_TXT” (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 “Column 30” (130) on output “Flat File Source Output” (2) and component “Source – Skinner-VOTERLIST-12-MAR-07_TXT” (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 “Column 31” (134) on output “Flat File Source Output” (2) and component “Source – Skinner-VOTERLIST-12-MAR-07_TXT” (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 “Column 32” (138) on output “Flat File Source Output” (2) and component “Source – Skinner-VOTERLIST-12-MAR-07_TXT” (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 “Column 33” (142) on output “Flat File Source Output” (2) and component “Source – Skinner-VOTERLIST-12-MAR-07_TXT” (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 “Column 34” (146) on output “Flat File Source Output” (2) and component “Source – Skinner-VOTERLIST-12-MAR-07_TXT” (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 “Column 35” (150) on output “Flat File Source Output” (2) and component “Source – Skinner-VOTERLIST-12-MAR-07_TXT” (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 “Column 36” (154) on output “Flat File Source Output” (2) and component “Source – Skinner-VOTERLIST-12-MAR-07_TXT” (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 “Column 37” (158) on output “Flat File Source Output” (2) and component “Source – Skinner-VOTERLIST-12-MAR-07_TXT” (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 “Column 38” (162) on output “Flat File Source Output” (2) and component “Source – Skinner-VOTERLIST-12-MAR-07_TXT” (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 “Column 39” (166) on output “Flat File Source Output” (2) and component “Source – Skinner-VOTERLIST-12-MAR-07_TXT” (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 “Column 40” (170) on output “Flat File Source Output” (2) and component “Source – Skinner-VOTERLIST-12-MAR-07_TXT” (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 “Column 41” (174) on output “Flat File Source Output” (2) and component “Source – Skinner-VOTERLIST-12-MAR-07_TXT” (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 “Column 42” (178) on output “Flat File Source Output” (2) and component “Source – Skinner-VOTERLIST-12-MAR-07_TXT” (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 “Column 43” (182) on output “Flat File Source Output” (2) and component “Source – Skinner-VOTERLIST-12-MAR-07_TXT” (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)
– Prepare for Execute (Success)
– Pre-execute (Error)
Messages
* Information 0x402090dc: Data Flow Task: The processing of file “C:\NYData\Skinner-VOTERLIST-12-MAR-07.TXT” has started.
(SQL Server Import and Export Wizard)
* Error 0xc0202004: Data Flow Task: The number of columns is incorrect.
(SQL Server Import and Export Wizard)
* Error 0xc0202025: Data Flow Task: Cannot create an OLE DB accessor. Verify that the column metadata is valid.
(SQL Server Import and Export Wizard)
* Error 0xc004701a: Data Flow Task: component “Destination – NY” (186) failed the pre-execute phase and returned error code 0xC0202025.
(SQL Server Import and Export Wizard)
– Executing (Success)
– Copying to [VoterRecords].[dbo].[NY] (Stopped)
– Post-execute (Stopped)
Messages
* Information 0x402090dd: Data Flow Task: The processing of file “C:\NYData\Skinner-VOTERLIST-12-MAR-07.TXT” has ended.
(SQL Server Import and Export Wizard)
– Cleanup (Success)
Messages
* Information 0x4004300b: Data Flow Task: “component “Destination – NY” (186)” wrote 0 rows.
(SQL Server Import and Export Wizard)
