To use the bulkapi (even the pkchunk variant) you will need to have a Work Directory set up for DBAmp - that’s what that error means ( Error: DBAmpWork directory does not exist. ).

How to do that depends on your version. That output says you have version 22.0.8304.0 - any version that starts with 22 works the same, and you can set up the Work Directory in the DBAmp Configuration Program, in the Settings dialog under the Configuration menu. The Work Directory is in the Properties section there.

If you have an older version (that would look like v5.1.9, for example), you also need to go to the the DBAmp Configuration Program, and there you can find it in the Options dialog under the Configuration menu.

In both cases, make sure to choose a folder on your local drive that your SQL Server instance has read/write access to!

Hi Dani-

What are the best practices for cleaning up all the CSV files created in the DBamp Work Directory since overtime they accumulate and grow?  Are users supposed to monitor and remove the old ones or is there a dbamp configuration/service/stored procedure that can help with this?  Can the older ones be removed? and if so what’s a safe timeframe for their removal?

Currently using version 5.1.3.0 but will be upgrading soon.

Thanks for your help, Brad.

There is not a stored procedure/configuration for it, but any of them can be removed, as long as they are not ones *just* created, ie still in use by a running procedure.