SSIS Connectors Test Setup instructions

By | March 31, 2017

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:


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

 

 

Leave a Reply

Your email address will not be published. Required fields are marked *