lundi 29 juin 2015

BCP command is not Working?

We just migrated our SQL server to a cloud machine.Everything seems working but we are facing some issues with BCP command. a)Whenever we run Job the job Process exit with Failure."The process cannot access the file because it is being used by another process. Process Exit Code 1. The step failed".I find out that the BCP.exe is still runing after doing his task.

b)BCP command import the data in table from file .It works correct but for % column it does not import the data completely it only load the data which is having % equals or greater than 1 . for others its giving

Starting copy... SQLState = 22001, NativeError = 0 Error = [Microsoft][SQL Native Client]String data, right truncation.

Any help appreciated

Aucun commentaire:

Enregistrer un commentaire