Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2004
    Posts
    2

    Angry Unanswered: bcp: starting copy...

    hello - i have this problem:
    i am able to use bulk insert script like
    "bulk insert demodb..table1
    from 'c:\filename.ext' with (formatfile = 'c:\bcp.fmt')"
    to import a binary file into sql server.
    table1 has 4 columns, noted column is number 2, type image, here's my format file:
    8.0
    1
    1 SQLIMAGE 0 100184 "" 2 logo ""
    i import only the binary file.
    however when trying to do the same using bcp with the same format file, it just says
    "starting copy..." and goes to sleep !
    any idea what i should do?
    i created a temp table with just an IMAGE column and then the bcp method works, but i rather need it with my current setup - table with 4 columns

    thank you

  2. #2
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    Any error or information on SQL error log for this behaviour.

    Can take help of PROFILER to see the activity during this execution.
    --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
  •