The Data Transformation Task will call a Insert Bulk command. Unfortunately
this is an Internal command which is not doented. The only solution I can
think of would be to create a linked server and use a Execute SQL Task (if
you still want to use DTS!) and use INSERT ... SELECT
Maybe someone else in this group or microsoft.public.sqlserver.dts may have
a better idea!
"Przemo" <p.dutkiewiczdeltatrans.pl> wrote in message
> Thanks. Your replay cleared me a lot of.
> But I'd like to notice something more. BULK INSERT allows
> only to copy from a text file and. My source is in Access
> and Transform Data Task is used in DTS. So it is not
> possible to write a BULK INSERT statement.
> So have you got any idea ?