[dba-SQLServer] (no subject)

Arthur Fuller fuller.artful at gmail.com
Mon Jul 2 09:06:46 CDT 2007


Wrap it in single quotes. I think that should do it.

On 7/2/07, jwcolby <jwcolby at colbyconsulting.com> wrote:
>
> 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
>
>



More information about the dba-SQLServer mailing list