BCP with ASP

[Newsgroup_User]

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.

[Newsgroup_User]

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.
>