You need to sign in to do that
Don't have an account?
Swamy P
Dataloader for mssql connection
Hi,
I am trying to use dataloader for directly loading data from salesforce to MSSQL database viceversa.Could you please suggest me the steps,by some posts i have seen that create database.xml file and etc..Is it by manually.and describe me the steps.
Thanks in advance.
The only thing I could think of is to use the dataloader to create the CSV export file and import it into your DB using the MS SQL "BULK INSERT" functionality. Here is an article explaining how to use bulk insert if you're not already familiar with it.
http://blog.sqlauthority.com/2008/02/06/sql-server-import-csv-file-into-sql-server-using-bulk-insert-load-comma-delimited-file-into-sql-server/