471,350 Members | 1,857 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,350 software developers and data experts.

C# BCP API

Joe
Hello,
I'm calling a stored procedure to bulk insert data but the procedure
doesn't like a unc address format being passed to it. I wondered if
anyone had tried to write an API to bcp as I think that could solve my
problem.

Regards,

Joe

Joe

--
Sent via .NET Newsgroups
http://www.dotnetnewsgroups.com
Dec 2 '05 #1
2 4875
Most likely it has to do with the user context under which the RDBMS is
running. That user probably has no permissions to the UNC share.

Regards

Joe wrote:
Hello,
I'm calling a stored procedure to bulk insert data but the procedure
doesn't like a unc address format being passed to it. I wondered if
anyone had tried to write an API to bcp as I think that could solve my
problem.

Regards,

Joe

Joe

--
Sent via .NET Newsgroups
http://www.dotnetnewsgroups.com

Dec 3 '05 #2
Hi ,

Maybe it's permission what the process is lacking.

The approach I used to bulk insert is creating a DTS package and later call
it from code, you can update the source/target directly from the code so
it's reusable. let me know if you want some code snips

cheers,

--
Ignacio Machin,
ignacio.machin AT dot.state.fl.us
Florida Department Of Transportation

"Joe" <bo*******@netscape.net> wrote in message
news:uu**************@tk2msftngp13.phx.gbl...
Hello,
I'm calling a stored procedure to bulk insert data but the procedure
doesn't like a unc address format being passed to it. I wondered if
anyone had tried to write an API to bcp as I think that could solve my
problem.

Regards,

Joe

Joe

--
Sent via .NET Newsgroups
http://www.dotnetnewsgroups.com

Dec 5 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

3 posts views Thread by William C. White | last post: by
2 posts views Thread by Albert Ahtenberg | last post: by
3 posts views Thread by James | last post: by
reply views Thread by Ollivier Robert | last post: by
1 post views Thread by Richard Galli | last post: by
4 posts views Thread by Albert Ahtenberg | last post: by
1 post views Thread by inderjit S Gabrie | last post: by
2 posts views Thread by Jack | last post: by
3 posts views Thread by Sandwick | last post: by
reply views Thread by XIAOLAOHU | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.