Jim Lawrence
accessd at shaw.ca
Mon Jul 2 14:02:28 CDT 2007
Hi John: What happens when you remove the extension and period? Jim -----Original Message----- From: dba-sqlserver-bounces at databaseadvisors.com [mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of jwcolby Sent: Monday, July 02, 2007 6:00 AM To: dba-sqlserver at databaseadvisors.com Subject: [dba-SQLServer] (no subject) Folks, I am trying to import (through the wizard) a file path into a field in SQL Server and am getting the following error. This is literally one of the strings: \\Stonehenge\PSM\Data\infutor\CSVExport\Infutor1.txt . The error message indicates that SQL Server doesn't like the \ or . character. Error 0xc02020a1: Data Flow Task: Data conversion failed. The data conversion for column "FileSpec" returned status value 4 and status text "Text was truncated or one or more characters had no match in the target code page.". (SQL Server Import and Export Wizard) Any idea how to make this OK with SQL Server? John W. Colby Colby Consulting www.ColbyConsulting.com _______________________________________________ dba-SQLServer mailing list dba-SQLServer at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-sqlserver http://www.databaseadvisors.com