[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