SSIS Connectors Test Setup instructions

You can use the scripts and solution/project files below to set up the same data migration test that I used to compare KingswaySoft to CozyRoc in the Part 4 of the Data Migration with SSIS series of posts:

• Part 1: Introduction
• Part 2: Overview
• Part 3: SSIS Data Connectors
• Part 4: Let’s put it all to test

Local table setup – this script will create a table and add 5000 records to it

DECLARE @counter int;

IF OBJECT_ID(‘TestEntity’) IS NULL
CREATE TABLE TestEntity(
[Id] [int] NULL,
[CRMId] [uniqueidentifier] NULL,
[Name] [nvarchar](50) NULL
)

DELETE FROM TestEntity

SET @counter = 0
WHILE(@counter < 5000)
BEGIN
INSERT INTO TestEntity(Id, Name) VALUES (@counter, ‘Name’ + CAST(@counter AS NVARCHAR(10)))
SET @counter = @counter + 1
END

CRM Solution to create a test entity 

ssistest_1_0_0_0

SSIS Project

SSIS Test Project