Re: Biztalk and SQLXMLBULKLOAD problem

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Christof [MVP] ("Christof)
Date: 08/18/04 

Date: Wed, 18 Aug 2004 20:15:14 +0200

Is there any difference in rights assigned to the user BizTalk Server runs
with and the user you code worked with previously please? (Having rights on
to the C:\ drive for example?)

Is this code resided in a separate assembly that is referenced inside your
orchestration or do you call it directly from within an expression shape
please? (Last option is the bad one...)

Best regards!
Christof 

-- 
Christof [Microsoft BizTalk Server MVP]
"Rebecca" <rclarke@community.nospam> wrote in message
news:C1447DA1-A5FE-496A-A69E-B1356E41966C@microsoft.com...
> I've got a test app that will run bulkload, but when I attempt to call the
> exact same code from my orchestration I get the following error:
> Error Message :QueryInterface for interface
> SQLXMLBULKLOADLib.ISQLXMLBulkLoad failed. Stack Trace :    at
> SQLXMLBULKLOADLib.SQLXMLBulkLoadClass.set_ConnectionString(String
> pbstrConnectionString)
>    at BulkLoadHelper.BulkLoadHelper2.LoadFile()
>
> Here's the code chunk that I'm calling:
> SQLXMLBulkLoadClass bulkLoad = new SQLXMLBulkLoadClass();
> bulkLoad.ConnectionString = "PROVIDER=SQLOLEDB.1;DATA
> SOURCE=localhost;DATABASE=HSI_ODS;integrated security=SSPI";
> bulkLoad.ErrorLogFile = "C:\\Errorlog.txt";
> bulkLoad.Execute("c:\\customermapping.xml", "c:\\customers.xml");
>
> Any ideas will be appreciated :)
> -- 
> Thanks,
> Rebecca