BCP packet size not working

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 7,2000 » Administration » BCP packet size not working

BCP packet size not working

Rate Topic

Display Mode

Topic Options

Author

Message

Frankie-464050

Posted Thursday, December 20, 2012 8:54 AM

SSC Rookie

Group: General Forum Members
Last Login: Tuesday, June 11, 2013 10:45 AM
Points: 35, Visits: 233

I have a Window 2008 R2 server 64-bit, SQL 2008 Enterprise 64-bit RTM I am doing large (hundred of millions of rows) BCP jobs and set the -a switch to 65535 but they all run at 32576 which I know was the max way back when but everything I read says 65535 is the max for the environment I'm working in.

What's not set? Where?

My sys admins can run stuff (non sql envriornment) at 65535 packet size

???? At a loss any help would be appreciated

Post #1399025

Frankie-464050

Posted Thursday, December 20, 2012 10:47 AM

SSC Rookie

Group: General Forum Members
Last Login: Tuesday, June 11, 2013 10:45 AM
Points: 35, Visits: 233

More info.

Running this BCP from inside xp_cmdshell (has to do with validation issues)

SQL Server default packet size is set to 4096 ....

so think that perhaps there is something in the SSMS/Query/SQL environment that is constricting the packet size to 32576

Post #1399064

« Prev Topic | Next Topic »

Permissions