Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2003
    Posts
    2

    Unanswered: BCP Entire DB in MYSQL 2000

    I have a stored proc that currently BCP 27 tables into a MS SQL 2000 DB. The original script was created to import FIXED-WIDTH. I have made the changes to TAB-DELIMITED. But the source db that outputs the TAB files is enclosing every field within double quotes("). I am getting a 'Invalid character value for cast specification' error on the first row which is an integer. Is there a parameter that I can set for bcp to strip out the "...".

    Thanks,
    JNunezNYC

  2. #2
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    Why don't you use DTS where you can specify the required settings for data.
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •