BCP In to a View

• Boraiah Manjunatha

  SSC Enthusiast

  Points: 165

  More actions

  April 2, 2007 at 12:07 pm

  #119272

  I am trying to bcp into a view using dblib bcpinit, bcpbind, bcpsendrow.......I am getting the following error:

  "Attempt to use Bulk Copy with a non-existent Server table"

  Does sql server support bcp into a View using dblib? If not is there a workaround?

  Any reply is appreciated.

  B.M

   

• SQL ORACLE

  One Orange Chip

  Points: 27807

  More actions

  April 3, 2007 at 8:51 am

  #698311

  Remember, view is a virtual table, not a real one. You need to put data into a real table.