function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
dgrissendgrissen 

SQL Server 2005 - SSIS Web Service Task?

Hi,

Has anyone had any luck/experience using SSIS in SQL server 2005 to download data in aggregate from sforce?  I know there is a new feature in the DTS designer called Web Service task but I am struggling to see how it would work with sforce.

Thanks,

Darrell

qmanqman

You could use my ole db provider code as a linked server to access sforce data as normal SQL tables.  Then to SSIS, the data looks like any other table.

Check out the beta at www.forceamp.com

Bill Emerson