Is it possible to config and use the data loader in batch mode to both export data from a salesforce db table and then import the data into my sql server db table?
You might find this article helpful - it's all about using Data Loader in batch mode. Although it doesn't specifically cover using a relational database as a target or source, the additional configuration is covered pretty well in the Data Loader documentation.
THANKS, every one. As a solution I downloaded the wdsl and went with calling the webservice to get my data and then pump it in the local database myself. Much easier than messing with the DataLoader.
You might find this article helpful - it's all about using Data Loader in batch mode. Although it doesn't specifically cover using a relational database as a target or source, the additional configuration is covered pretty well in the Data Loader documentation.
Hope this helps.
Message Edited by RickyG on 09-28-2007 03:44 PM