We’re making our first step with bulk loading in DI 11.7.0 (windows) to a Sybase IQ 12.7 database.
After solving minor issues such as ftp configurations and file locations, we’ve realized that DI jobs create the bulk file in the \log\BulkLoader directory previous to send it via ftp to the IQ server.
The problem we are facing is that these files, usually large ones, remains in the \log\BulkLoader directory apparently when the bulk copy operation fails or generate some sort of errors.
(we’ve already checked the “Clean up bulk loader directory after load”)
So, the questions are:
Is there a way to tell DI to generate these files in other directory?
Does DI have a builtin cleanup for these files or is neccesary to create a custom task (such as deleting the directory programatically)?
Though this post is quite old and perhaps you have found an answer too, however to your 1st quetsion its Datastore property change it to whatever location to want and cleanup means from remote directory after ftp not from local folder/directory.
(BOB member since 2006-02-02)
