Setting Fast Load options | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Setting Fast Load options

Hi All, I’m a newbie, was wondering if someone could help me with this… DBPROPSET RFLPropSet[1];
DBPROP RFLProperties[1]; RFLProperties[0].dwOptions = DBPROPOPTIONS_REQUIRED;
RFLProperties[0].colid = DB_NULLID;
RFLProperties[0].dwStatus = DBPROPSTATUS_OK;
RFLProperties[0].dwPropertyID = SSPROP_FASTLOADOPTIONS;
RFLProperties[0].vValue.vt = VT_BSTR;
RFLProperties[0].vValue.bstrVal = SysAllocString ( L"TABLOCK" );
RFLPropSet[0].guidPropertySet = DBPROPSET_ROWSET;
RFLPropSet[0].cProperties = 1;
RFLPropSet[0].rgProperties = RFLProperties; hr = pIOpenRowsetFL->OpenRowset ( NULL, &TableID, NULL, IID_IRowsetFastLoad,
1, RFLPropSet, (LPUNKNOWN *)&pIFastLoad ); If I don’t set any properties the prog runs fine. Setting FASTLOADOPTIONS returns an error in dwStatus. I can’t find any useful documentation or examples on this. I’m just using "TABLOCK" as an example here – in reality I wanted to specify ORDER and BATCHSIZE. Thanks in advance.
]]>