Connect to Salesforce Data as a Linked Server
Use the TDS Remoting feature of the ODBC Driver to set up a linked server for Salesforce data.
2018-07-27 (first published: 2015-08-18)
7,412 reads
Eric Madariaga
Synchronize Salesforce with SQL Server using SSIS
Easily synchronize live Salesforce data with SQL Server using the Salesforce SSIS DataFlow Tasks.
2014-09-30
5,984 reads
Connect QuickBooks to SQL Server through SSIS
This example uses an SSIS workflow to populate a database with QuickBooks data.
2012-05-28
4,717 reads
Blogs
Goal Progress for Jan 2023
By Steve Jones
The grade for January is a D. Details below, but just not making a...
Context Info Across Databases–#SQLNewBlogger
By Steve Jones
Does Context Info work across databases? This post shows it does. Another post for...
Introducing… Data On Rails!
By DataOnWheels
Data On Rails is a Data On Wheels project designed to give a platform...
Forums
Identity column and "EntityID" column naming convention
This isn't* specific to 2022, but SQL in general. I will be joining a...
Replace Primary Server keeping same Log Shipping Server
I have a two node SQL Standard 2014 Failover Cluster at the primary site. ...
Memory Issue With A SQL Server Express 2019 Server Database Application
Hi, I have just moved a DB from an old HP laptop, to a...
Ask SSC