+ Start a Discussion
Swamy PSwamy 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.

DaveHDaveH

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/