I agreed with you reg pull option but customer is not ready to agree this option. I requested below options. Any how we have done different way using etl tools....

Yes, we can't user bulk insert in window system because customer is not ready to open UNC path . I know bulk insert will work some how efficient way this...

Hi Steve,

Thanks for your prompt response. We are passing password with encrypt password due to security reason. Customer is not agreed to put password directly in bcp command...

-T is trusted mode but our case it is not applicable because file was sitting in remote location. 

-t "~" -- I already explained above nonstandard delimiter are not...

Any inputs ?

The other query was in queue in customer side, they are working on it because I explained that same query which is working on local setup not in server so...

As per your suggesstion , i have done this testing in local server env.

C:\Users\test>bcp test.dbo.AUDIT in "D:\BCP\TEST.txt" -T -t$$ -c -r "0x0a" -S ADMIN\SQLEXPRESS -U sa -P XXXX

Ok jeff,

I am trying to load same file in my local setup in windows server , now i can see some error in out.log file .i tired get...

No error, it was really strange ? Is there any chance exceeded row size limit will encounter this kind of issue ?

Can we check how much row size...

Why am asking, for testing purpose I have kept one record but it was successful with zero records. Do u ve any idea ? Below is the command
./bcp dbo.test...

Thom, how to set maximize size row limit? Is there any command to check row size limit ?

HI  Jeff

I did the change as per your input but no lick still same issue . any one can help ?

./bcp dbo.test in "/test/bcp/bcp_test.dat" -t~~, -c...

HI All,

in file have  around 100000 records but command was successful with 0 records. No error described in error log. Any inputs highly appreciated.
./bcp dbo.test in...

@thom-2 A: -

You need to configure Kerberos, or use SQL Authentication.       
Do you have any link or doc which i can refere...

@sgmunson : Apologies for spell mistake.
Yes, I am not able to ping sql server from my Linux box. I will inform to...