We're needing to load some tables with up to tens of
millions of rows. This will usually be monthly but
occasionally will be needed on demand. We'd like to use
bulk insert for speed. Our problem is that we have a
developer(not me) who has written a C# app to manipulate
and parse the data coming to us from various sources. We'd
like to do the bulk insert as part of his processing. He
has written a stored procedure to execute the bulk insert
but is unable to run it due to permissions. We've created a
user with bulkinsert administrator but we can't get it to
work. The error is We don't want sysadmin passwords in
the code and we don't want developers having sysadmin
rights to production servers.

If I create a package with a bulkinsert task,can I get
around these issues by having him execute dtsrun from his
code?

Can he use the package object to run the package?

With either of these will the work happen on the sql server
or on the machine where his C# app resides?

I may have more questions later...

Thanks in advance...
MarkA