Skip to main content
Inspiring
October 21, 2006
Question

BCP with ASP

  • October 21, 2006
  • 1 reply
  • 207 views
Hi All,

Can anyone tell me if it is possible to call SQL Server BCP commands from
ASP? and if so how it can be done.

Many thanks.


This topic has been closed for replies.

1 reply

Inspiring
October 23, 2006
Yeah, it is, but you'd have much more luck and far fewer headaches if you
used a DTS package instead. (A DTS package can execute a BCP command, too;
you don't have to use ActiveX transforms.)

A DTS package can be executed by calling a stored procedure that uses
sp_OACreate and all its bretheren to build and execute a "DTS.Package" COM
object. I've found that to be the easiest way to call that kind of function
from ASP.


"Bravo4" <a@a.com> wrote in message
news:ehdo1i$6jr$1@forums.macromedia.com...
> Hi All,
>
> Can anyone tell me if it is possible to call SQL Server BCP commands from
> ASP? and if so how it can be done.
>
> Many thanks.
>