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 |
|
michaelh613
Starting Member
1 Post |
 Posted - 2007-05-17 : 23:03:53
|
| I am getting an error importing a comma deliminated file. I deleted all single ' quotes from the file. I can imported tab deliminated files without and errorHere is the message I get using the import wizard.Its a giant file around 3 gb, 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) |
|
|
mwjdavidson
Aged Yak Warrior
735 Posts |
Posted - 2007-05-18 : 09:43:09
|
This to me suggests that you've probably got additional commas within the the data which is throwing the mapping out of whack: quote:
* Error 0xc0202004: Data Flow Task: The number of columns is incorrect.(SQL Server Import and Export Wizard)
I'm assuming that the single quotes that you've removed from the file were there as text qualifiers. The import/export wizard should be able to use this to import correctly.Mark |
 |
|
|
|
|
|
Error importing into sql server