fmdf
5 years agoNew Contributor III
Salesforce data types not coming over when loading SQL Server
I am grabbing an object in Salesforce using the Salesforce Read Snap.
I am using SQL Bulk Load and it is flagged to create table if it doesn’t exist.
My numeric types are not being created in SQL. Almost everything is coming over as varchar(8000).
I have read the documentation on this snap many times and it is not well written to explain how do I get the data types to come across and create the tables correctly.
Anyone have issues with this? Do I use XML/Json? Bulk API makes sense to use because I am loading a data warehouse.
I’m stuck.