Something like below:

Exec dbo. Sp_Number '1,2,3,4,5'

Result Set
1       USA   Chicago
2       UK     England
3      ...

. Microsoft (R) SQL Server Execute Package Utility Version 12.0.4100.1 for 32-bit Copyright (C) Microsoft Corporation. All rights reserved.  Started: 9:41:09 AM Error: 2017-05-15 09:41:10.70  ...

To be more specific this is what I mean

Column

14522345

15235642

16289563

16287423

30245123

31451831

32452632

31458142

Column AColumn B

1452234530245123

1523564231451831

1628956332452632

1628742331458142

The column has values starting with 1 and 3 as sent above.

The column should be split into two

Rows starting with 1 into column A

Rows starting with 3 into column...

Try this.

DECLARE @TableName As varchar(500), @TableSchema As varchar(500)

DECLARE @sql NVARCHAR(MAX)

SET @TableName = 'Table_Name'

SET @TableSchema = 'dbo'

SELECT @sql = STUFF((SELECT

'

UNION ALL

select ' + QUOTENAME(Table_Name,'''') +...

Yes you are right. I have a two date fields to compare.

But whats the thing I should do in SSIS to achieve this since it is across different servers.

I'm comparing on combination of keys.

I know lookup is not a good option for millions of rows.

Is there any other way to grab the difference and insert into table B.