Error in "BCP IN" operation
Try using with -c which is character instead of -n native

bcp "select * from Database_A.dbo.tbl_Employee" queryout "D:\test.txt" -S Server_Name -c -T

bcp "Database_B.dbo.tbl_Employee" in "D:\test.txt"-S Server_Name -c -T


Or an alternative is to create a format file.


Create format file syntax is:

bcp Database_A.dbo.tbl_Employee format -null -f D:\BCPFormat.fmt -n -T

Export as normal with native:

bcp "select * from Database_A.dbo.tbl_Employee" queryout "D:\test.txt" -S Server_Name -n -T 

Import with -k keeps nulls and format file, no -n flag needed.

bcp Database_B.dbo.Employee in "D:\Test.txt" -S Server_Name -f D:\BCPFormat.fmt -k -T