BCP copy out failed

• jiaying.wang

  SSC Veteran

  Points: 211

  More actions

  December 1, 2011 at 5:20 pm

  #391011

  I am running a command which Had been always working until today.

  EXEC master..xp_cmdshell 'bcp ultisaas.dbo.BLDS_Kaiser out c:\2012OpenEnrollment\bloodsourcefile_ca.txt -T -c -t'

  I gout the output as following:

  NULL

  Starting copy...

  SQLState = 37000, NativeError = 4121

  Error = [Microsoft][SQL Native Client][SQL Server]Cannot find either column "MASTER" or the user-defined function or aggregate "MASTER.dbo.ParseAuditCXNContext_Info", or the name is ambiguous.

  SQLState = S1000, NativeError = 0

  Error = [Microsoft][SQL Native Client]Unable to resolve column level collations

  NULL

  BCP copy out failed

  NULL

  Anybody can give a help on this error that I've never seen and couldn't find out on google as well.

  Thanks!

• spaghettidba

  SSC Guru

  Points: 105732

  More actions

  December 2, 2011 at 3:06 am

  #1415772

  Does the query you use in BCP work when run from SSMS?

  -- Gianluca Sartori

• SGT_squeequal

  SSCertifiable

  Points: 7167

  More actions

  December 4, 2011 at 3:57 am

  #1416390

  Have you tried running BCP from a batchfile

  ???

  SET database=yourdbname

  SET Sever=yourSQLserverinstance

  bcp %DATABASE%.dbo.yourtable out "yourtable.bcp" -n -T -S%

  ***The first step is always the hardest *******

• john.campbell-1020429

  Ten Centuries

  Points: 1194

  More actions

  December 7, 2011 at 8:18 am

  #1418131

  So you are saying that this ran yesterday and the day before and etc but now it won't run. If this is the case, then someting has changed, probably the permissions on the folder that the file is written to. That is the first thing that I would check.