Thursday, November 29, 2012 7:25 PM
We have recently migrated sqlserver 2005 to 2012.
our .net exe call the below argument to import files from text
C:\Users\Bachumy\Database Migration\GMCSI.MARS.6\bin\Debug>"bcp" "MR_ARG_GM_CSI.Process.tmpGlobalWtySSS" IN "\\\\mau001appimg01\IMG_GM\T_drive\CSI\PH1\Names\SSSUSfromGlobalSATURNCSIT.2012_11_08.04_12_37.txt" -f "G:\40101_GMCSI\GM CSI\BASE\MARS\Application\temp\DataimportValidate_99.fmt" -SFENSQLMRD20 -1 32764 -m 10 -CRAW -e "G:\40101_GMCSI\GM CSI\BASE\MARS\Application\temp\DataimportValidate_99_20122829112805.cmd.err" -T
and thorws the below exception
Sql state =08S01, native eroor =50
Eroor= [Microsoft][SQL Native Clinent] SSL provider:Packaet size too large for SSL Encrypt/decrypt operations .
This issue occurs if the file limit exceeds 13 KB .
Help required on this.Tanking you in advance
Thursday, December 06, 2012 7:47 AMModerator
SQLState: 08S01 indicates that the communication link between the driver and the data source to which the driver was attempting to connect failed before the function completed processing.
For the error: Packaet size too large for SSL Encrypt/decrypt operations, we can reconfigure the file size using following code:
sp_configure 'packet', size
reconfigure with override
TechNet Community Support
- Marked As Answer by Iric WenModerator Thursday, December 06, 2012 9:45 AM
Friday, December 14, 2012 10:04 PM
Thanks for your reply...
i have resolved this issues by changing the packet size from 32764 to 16383.
- Marked As Answer by Bachu malli Friday, December 14, 2012 10:07 PM