Floating Point Numbers in BCP File

Hi,
I am BCPing in a tab-delimited text file and I am getting this error
message:
Starting copy...
SQLState = 22005, NativeError = 0
Error = [Microsoft][ODBC SQL Server Driver]Invalid character value for cast
specification
The text file records look like below:
200509 67195 M12AB00 67195 SSL TEST RECORD 7217 240.41
200509 67338 DNMXAED 67338 CTA TEST RECORD 50 237.5
Not sure if that floating point number at the end of the file is the cause
of this problem or not.
Any ideas on how to solve the problem?
JDJoe Delphi wrote:
> Hi,
> I am BCPing in a tab-delimited text file and I am getting this
> error message:
> Starting copy...
> SQLState = 22005, NativeError = 0
> Error = [Microsoft][ODBC SQL Server Driver]Invalid character value
> for cast specification
> The text file records look like below:
> 200509 67195 M12AB00 67195 SSL TEST RECORD 7217 240.41
> 200509 67338 DNMXAED 67338 CTA TEST RECORD 50 237.5
> Not sure if that floating point number at the end of the file is the
> cause of this problem or not.
> Any ideas on how to solve the problem?
> JD
Have you verified there are actually TAB characters in the file where
they should be? You might try using the DTS Import Wizard to see if that
works. The wizard will show you the parsed data based on your
delimiters, so that might clue you in to the problem.
David Gugick
Quest Software
www.imceda.com
www.quest.com|||Joe Delphi (delphi561@.nospam.cox.net) writes:
> I am BCPing in a tab-delimited text file and I am getting this error
> message:
> Starting copy...
> SQLState = 22005, NativeError = 0
> Error = [Microsoft][ODBC SQL Server Driver]Invalid character value for
> cast specification
> The text file records look like below:
> 200509 67195 M12AB00 67195 SSL TEST RECORD 7217 240.41
> 200509 67338 DNMXAED 67338 CTA TEST RECORD 50 237.5
> Not sure if that floating point number at the end of the file is the cause
> of this problem or not.
> Any ideas on how to solve the problem?
Please post the CREATE TABLE statement for the table. It's impossible to
tell without that information what is going on.
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp

Firewall Setting for XP Professional

We have installed SQL Server Evaluation copy on a Windows
XP Professional Workstation with SP2 installed. We also
installed Reporting Services on that workstation as well.
We would like to access the reports on that workstation
from a remote workstation. In this way, we would like to
know what is the best way to open the firewall ? Is it
only for us to add C:\Program Files\Microsoft SQL
Server\MSSQL\Binn\sqlservr.exe in the exception list ?
ThanksHi
http://support.microsoft.com/?kbid=841249
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Daniel" wrote:
> We have installed SQL Server Evaluation copy on a Windows
> XP Professional Workstation with SP2 installed. We also
> installed Reporting Services on that workstation as well.
> We would like to access the reports on that workstation
> from a remote workstation. In this way, we would like to
> know what is the best way to open the firewall ? Is it
> only for us to add C:\Program Files\Microsoft SQL
> Server\MSSQL\Binn\sqlservr.exe in the exception list ?
> Thanks
>
>

Firewall Setting for XP Professional

We have installed SQL Server Evaluation copy on a Windows
XP Professional Workstation with SP2 installed. We also
installed Reporting Services on that workstation as well.
We would like to access the reports on that workstation
from a remote workstation. In this way, we would like to
know what is the best way to open the firewall ? Is it
only for us to add C:\Program Files\Microsoft SQL
Server\MSSQL\Binn\sqlservr.exe in the exception list ?
Thanks
Hi
http://support.microsoft.com/?kbid=841249
Regards
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Daniel" wrote:

> We have installed SQL Server Evaluation copy on a Windows
> XP Professional Workstation with SP2 installed. We also
> installed Reporting Services on that workstation as well.
> We would like to access the reports on that workstation
> from a remote workstation. In this way, we would like to
> know what is the best way to open the firewall ? Is it
> only for us to add C:\Program Files\Microsoft SQL
> Server\MSSQL\Binn\sqlservr.exe in the exception list ?
> Thanks
>
>

Firewall Setting for XP Professional

We have installed SQL Server Evaluation copy on a Windows
XP Professional Workstation with SP2 installed. We also
installed Reporting Services on that workstation as well.
We would like to access the reports on that workstation
from a remote workstation. In this way, we would like to
know what is the best way to open the firewall ? Is it
only for us to add C:\Program Files\Microsoft SQL
Server\MSSQL\Binn\sqlservr.exe in the exception list ?
ThanksHi
http://support.microsoft.com/?kbid=841249
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Daniel" wrote:

> We have installed SQL Server Evaluation copy on a Windows
> XP Professional Workstation with SP2 installed. We also
> installed Reporting Services on that workstation as well.
> We would like to access the reports on that workstation
> from a remote workstation. In this way, we would like to
> know what is the best way to open the firewall ? Is it
> only for us to add C:\Program Files\Microsoft SQL
> Server\MSSQL\Binn\sqlservr.exe in the exception list ?
> Thanks
>
>