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

    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:
    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
    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

Posting Permissions

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