0

I want migrate data from salesforce to SQL server and I am using SSIS connectors for salesforce. I am creating single SSIS package which fetch data for all objects and insert into SQL server. I tried using following connectors for salesforce.

Connector 1 : Kingswaysoft https://www.kingswaysoft.com/

Connector 2 : CData https://www.cdata.com/kb/articles/ado-ssistask-sf.rst

Connector 3 : SSIS PowerPack - https://zappysys.com/onlinehelp/ssis-powerpack/index.htm https://zappysys.com/products/ssis-powerpack/ssis-salesforce-source-connector/

In all the connectors I am unable to provide different columns(salesforce fields) dynamically in SOQL query using SSIS variables.

Saqib Ali
  • 3,953
  • 10
  • 55
  • 100
Satishakumar Awati
  • 3,604
  • 1
  • 29
  • 50
  • 1
    SSIS is build for static metadata ETLs. If you want one solution for all objects (with dynamic objects and SQL tables) you might need to implement a custom process in C# or VB that uses Salesforce's BulkApi. – EzLo Jun 19 '18 at 09:20
  • 1
    Could you please provide me with reference links. I am a C# beginner. – Satishakumar Awati Jun 19 '18 at 09:23

1 Answers1

0

I agree with the comments that SSIS is for static ETL & you can work around with C# script task for dynamic metadata.

As an Alternative, you can try conditional branches and run two different tasks based on expression. Read Add expressions to precedence constraints.

Not sure how many dynamic columns we are talking here, but for discussion sake let’s take 2 different columns has to be filled in salesforce destination based on source column, then have 2 branch.

Arun Vinoth-Precog Tech - MVP
  • 22,364
  • 14
  • 59
  • 168