Interview Question in Sql Server 2000


 

Interview Question :: NET 2.0 Bulk Loader

I am using the new .NET 2.0 Bulk Loader to import data from a Fox Pro table into SQL 2000. This worked when both were local. But when trying to import Fox Pro data on a server, the error message tells me it cannot find the file. I am sure it is a permissions error. Does anyone know how to pass credentials or does anyone know under what id the Bulk Loader would be trying to ge this data?
by ksk