I have a dts where I am transfering data from dbf to sql
server database.
I receive de following message but I did not find answer
in microsoft knowledge base.
Do you know something about it?

-2147008507 (80074005); Provider Error: 0 (0)

Error string: Could not acquire a FastLoad
session.Unspecified error

Error: -2147467259 (80004005); Provider Error: 0 (0)

Error string: Timeout expired

Thanks a lot
Fabi

Hi, Fabiana

As far as I know, you can't use 'Fastload mechanism' in
your 'Data Transform Task' for dbf to sql transformation.
This mechanism is only available for MSSQL to MSSQL
transformation. Turn off the 'Fastload' in the option pane
of the 'Data Transform Task'.

Hope it helps
Regards,
Jono Indrawijaya - MCDBA
PT. eBiz Cipta Solusi - Microsoft Certified Partner
Indonesia

Fast load should be available for dbf to sql because it really only affects
the loading into sql side. Use the MS OLE-DB provider for SQL. Perhaps you
could also try another dbf provider such as the FoxPro one.


--
Darren Green
http://www.sqldts.com

"Jono Indrawijaya" <jono (AT) ebizcipta (DOT) com> wrote