Category: SSIS

Dynamics 365 KingswaySoft SSIS Integration

To create a KingswaySoft integration, go through the steps. In SSDT, select new Integration Services Project: A new project is created: Under Data Flow you will see new KinsgwaySoft options: In SQL, create a Customers table in a TEST database, with sample data: Add a Data Flow task: Double click on the data flow task, add an ADO.NET data source: Create a new connection to the database: Add a CRM … Continue reading Dynamics 365 KingswaySoft SSIS Integration

Dynamics 365 KingswaySoft Install

To install the KingswaySoft adapter for Dynamics CRM, go to http://www.kingswaysoft.com/products/ssis-integration-toolkit-for-microsoft-dynamics-365/download Download the suitable version: Run the exe: Click on Custom to view the components: License Manager:  

SQL Server Integration Services (SSIS) – Your First Integration

Here I will go through a basic example of using SQL Server Integration Services (SSIS) to create an integration. I am using SQL Server 2012 with Visual Studio 2013. To get started, first download SQL Server Data Tools (SSDT) from the Microsoft website here. Install the file. Next, go to Start->Microsoft SQL Server->SQL Server Data Tools for Visual Studio 2013: This will open Visual Studio. Under Business Intelligence, select “Integration Services Project” and … Continue reading SQL Server Integration Services (SSIS) – Your First Integration