BULK INSERT WITH TEMPRARY TABLE VARIABLE

• anup_snwn

  SSC Enthusiast

  Points: 174

  More actions

  December 28, 2007 at 6:38 am

  #201961

  hi friends

  i am using bulk insert cmd using my table name

  but i am facing error....SO

  IS IT POSSIBLE TO USE BULK INSERT WITH TEMPRARY TABLE VARIABLE

  THANX IN ADVANCE...........

• Adam Haines

  SSC-Insane

  Points: 23217

  More actions

  December 28, 2007 at 10:37 am

  #763341

  This is not possible using bulk insert. Try using Openrowset with the BULK option.

  More Info:

  http://msdn2.microsoft.com/en-us/library/ms175915.aspx

  ---

  
  My blog: http://jahaines.blogspot.com