hi,

I follow www.sqldts.com/default.aspx?225 to setup my client environment.
And I use DTSBulkExport that I download from www.sqldts.com to export data ,
it looks fine when I execute my package within a SQL SERVER and AS
environment.

But I got below error while executing the same package.

DTSRun OnError: ExportData_Step , Error = -2147219504 ( 800407D0)
Error string : BulkExport_P_Step: Class: DTSBulkExport
Source: GetSQLServer
Error Number: 429
Error Description: ActiveX component can't create object
Error Source: DTSBulkExport
Help file:
Help Context: 0

Any ideas is very appreciated.

Thans.

The DTS Bulk Export task is not included with DTS it is a custom task.

It would seem you have not registered the component

--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.Konesans.com


"Steffi" <steffibev (AT) hotmail (DOT) com> wrote

hi,
I have install DTSBulkExport , and still doesn't work.
Any other ideas ?
Thanks.

The bulk export task is a wrapper around the SQL-DMO BulkCopy object, so
it requires SQL-DMO to be installed locally on the machine that executes
the package.

Checkout Redist.txt on the SQL CD for info on distributing SQLDMO, or
just install the SQL Client Tools.




In message <ukU7IrLtEHA.2804 (AT) TK2MSFTNGP14 (DOT) phx.gbl>, Steffi
<steffibev (AT) hotmail (DOT) com> writes
--
Darren Green (SQL Server MVP)
DTS - http://www.sqldts.com

PASS - the definitive, global community for SQL Server professionals
http://www.sqlpass.org