BCP error

• espanolanthony

  SSCarpal Tunnel

  Points: 4204

  More actions

  October 27, 2009 at 7:55 am

  #139707

  I am running this script but I get the error below. Does someone have any idea.

  use

  tempdb

  go

  create

  view vw_bcpMasterSysobjects

  as

  select

  top 100 percent

  name

  ,

  crdate

  = convert(varchar(8),

  crdate

  , 112) ,

  crtime

  = convert(varchar(8), crdate, 108)

  from

  master..sysobjects

  order

  by crdate desc

  go

  declare

  @sql varchar(8000)

  select

  @sql = 'bcp tempdb..vw_bcpMasterSysobjects out \\tersclient\d\sysobjects.txt -c -t, -T -S' + @@servername

  exec

  master..xp_cmdshell @sql

  this is the error :------------- ---- -------------------------------------

  SQLState = S1000, NativeError = 0

  Error = [Microsoft][SQL Server Native Client 10.0]Unable to open BCP host data-file

  NULL

• mcvilbar

  Say Hey Kid

  Points: 701

  More actions

  October 27, 2009 at 10:21 am

  #1071326

  Please check if it has rights on the folder that you have specified. Or else, just use SSIS to do it.