Re: Fast load options in OpenRowset

mweeks (mweeks@xxxxxxxxxxxxxxxxxxxxxxxxx) writes:
> I'm loading data that's already in primary key order to a large existing
> table. I hoped to exploit the SSPROP_FASTLOADOPTIONS. About all I can
> find on MSDN is "This property is the same as the -h "hint[,...n]"
> option of the bcp utility". If I use any of the documented hints I get
> an error in the dwStatus property field. e.g. a simple "TABLOCK"...
>
> 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 );
>
> The program runs fine if I OpenRowset with zero properties and a NULL
> property set. I've tried "HINT TABLOCK" but that's not right either.
> Anybody, what am I doing wrong? Thanks.

Just a check, you are running VariantInit on RFLProperties[0].vValue,
aren't you?




--
Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
.

Relevant Pages

  • Re: Query training -- Complex queries
    ... > Update PositionsEOM ... Here you don't have a derived table, but a correlated subquery. ... UPDATE in Books Online. ... is not written for SQL Server. ...
    (microsoft.public.sqlserver.server)
  • Re: Linked Server: How to check if server exists?
    ... The root problem is described in the Books Online topic Batches. ... Rick Byham, SQL Server Books Online ... linked server don't run on those development machines not having that linked ...
    (microsoft.public.sqlserver.connect)
  • Re: STORED PROCEDURE - passing table name as a parameter
    ... T-SQL, is that you get problems if the view definition does not fit into ... will need to query other system tables, for instance syscolumns. ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ... Books Online for SQL Server 2005 at ...
    (comp.databases.ms-sqlserver)
  • Re: Problem when changing Views
    ... There aree several reasons. ... I use neither of the tools, but I guess that Design View resubmits the ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ... Books Online for SQL Server 2005 at ...
    (comp.databases.ms-sqlserver)
  • Re: SQL 2005: Help files not valid?
    ... Please try the following instructions to remove and reinstall Books Online. ... If this doesn't solve the problem, we'll need to get the Visual Studio folks ... In Add or Remove Programs, select Microsoft SQL Server 2005, and then ... Complete the remaining steps in the Installation Wizard. ...
    (microsoft.public.sqlserver.setup)
Loading