<div>
Can you give the syntax of how you are importing? &nbsp;You should be specifying a Column Delimiter.
</div>


Can you give the syntax of how you are importing?  You should be specifying a Column Delimiter.

<div>
I figured it out - so you know, I was using DTS do to the import through. &nbsp;The problem was I had selected the wrong row delimiter.<br />
<br />
Thanks for your input!<br />
<br />
Saladart<br />
<br />
<br />

</div>


I figured it out - so you know, I was using DTS do to the import through.  The problem was I had selected the wrong row delimiter.

Thanks for your input!

Saladart




<div>
<div class="content wysiwyg-content">
I have been trying to successfully import a | delimited file into a SQL database with no success. &nbsp;I continue receiving an error message about non-whitespace characters.<br />
<br />
I read about using DTS to strip out the non-white characters by using the TRIM function. &nbsp;I am not a programmer - learning, however - and am asking for assistance in completing a DTS package that will strip out all of the non-whitespace characters so I can successfully conduct an import from this file.<br />
<br />
I am not sure what information to provide so please let me know what you will need to provide a solution.<br />
<br />
Thanks!<br />
<br />
Saladart
</div>
</div>


I have been trying to successfully import a | delimited file into a SQL database with no success.  I continue receiving an error message about non-whitespace characters.

I read about using DTS to strip out the non-white characters by using the TRIM function.  I am not a programmer - learning, however - and am asking for assistance in completing a DTS package that will strip out all of the non-whitespace characters so I can successfully conduct an import from this file.

I am not sure what information to provide so please let me know what you will need to provide a solution.

Thanks!

Saladart

IMPORTING CSV FILE USING BCP OR BULK INSERT

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.