Moveing data from SQL server

I have sql server table with 400K+ records. Some of this data has columns with commas and other special characters in it.

What is the best way to export the data from SQL server in a format that can be imported in SF?

Thanks

John

July 22, 2009
·
Answer
·
Like
0
·
Follow
0

start_s
Hello,

As a representative of Apatar, I suggest you using our free open source ETL tool. It has connectors for MSSQL and Salesforce (supports Developer, Professional (if API is enabled) Enterprise and Unlimited editions). Also it has a number of functions that can help you replace your special character. Thus, you may export your records directly from SQL server and import them directly to Salesforce.

Using sql and SOQL queries within the connectors, you can achieve the best results.

If you need our assistance feel free to contact us or post your questions here.

Regards,
Sergei

sergei.l at apatar.com
______________
www.apatar.com
www.apatarforge.org

July 24, 2009
·
Like
0
·
Dislike
0

You need to sign in to do that.

Need an account? Sign Up

Have an account? Sign In

Dismiss

Browse by Topic

Welcome to Support!

Show

sorted by

Moveing data from SQL server

You need to sign in to do that.