The SQL Server Integration Service is an ETL (Extract Transform and Load) Tool from Microsoft for building enterprise-level data integration and transformation solutions.
It can be used for basic data integration and workflow applications but also can be used to perform broad data migration tasks. It features a data warehousing tool used for data extraction, transformation, and loading.
This tutorial assumes that you have ODBC drivers installed and a data source configured. If you have not yet done these steps, please follow these instructions. Ensure that Visual Studio and ODBC Driver architecture matches. For example, if you have a 64-Bit Microsoft Visual Studio installed then you need to have the 64-Bit version of Progress DataDirect ODBC drivers installed. Most likely, your Visual Studio would be a 32-bit version and you would need a 32-bit driver.
2. Configure a data source for your database. See the DataDirect documentation for assistance with setting up your data source. The sample below uses a data source.
1. After the DataDirect Salesforce ODBC driver has been installed, open ODBC Administrator to configure the connection and click on Add.
2. Choose the “DataDirect X.X Salesforce” driver and click on “Finish.”
3. You should now see the ODBC Salesforce Driver Setup pop-up window launched. Add your Data Source Name, hostname, username, and other credentials, and click on “Apply” and then “Test Connect.” If you are connecting to a sandbox use test.salesforce.com instead of login.salesforce.com as your Host Name. Leave the security token blank if you do not have one.
4. The Logon Dialog will pop up. Enter your username and password and click on “OK.”
5. A pop-up window will confirm that the connection is established.
1. Open Microsoft Visual Studio. You need to create a new SSIS project by going to File → New → Project (as shown in the picture below).
2. A new window will appear, and inside that select Integration Service Project (If not appearing, go to Templates → Business Intelligence → Integration Services left side of the window).