How Can This Code Be Improved?

Hi Guys,

What I am trying to do is pretty simple, comparing two identical tables which are located on two different servers.

When I run this code as "Query" on any server the "query" executes fine, but when I run the same code as T-SQL task on SSIS (as a stored procedure), the code fails half the times. I am guessing that there is connection time out issue in SSIS. Can anyone suggest how to increase connection time on T-SQL task of SSIS? Alternatively, if someone can come up with a better, efficient code that accomplishes the same, I will greatly appreciate it.

Here's the code




Code Snippet
IF NOT EXISTS (SELECT * FROM TPM.SYS.OBJECTS WHERE NAME = 'PHONES_ADDED')
CREATE TABLE TPM.DBO.PHONES_ADDED
([FKEY_ID] [varchar](16) NULL ,
[PHONE] [varchar](50) NULL ,
[TYPE] [varchar](10) NULL ,
[VALID_START_DATE_TIME] [datetime] NULL,
[VALID_END_DATE_TIME] [datetime] NULL,
[CUSTOMER_ID] VARCHAR(16),
[DATABASE] VARCHAR(16),
[ADDED_ON] VARCHAR(50),
[EMAIL] VARCHAR(128),
[E_MAILED] CHAR(1))


INSERT INTO TPM.DBO.PHONES_ADDED
(FKEY_ID, PHONE, [TYPE], VALID_START_DATE_TIME, VALID_END_DATE_TIME, [DATABASE], ADDED_ON)

SELECT A.FKEY_ID, A.PHONE, A.[TYPE], A.[VALID_START_DATE_TIME], A.[VALID_END_DATE_TIME] , 'TC_WTI', CONVERT(VARCHAR(50), GETDATE(), 121)
FROM PHONE A LEFT OUTER JOIN [LV-SQL2].[TC_MASTER].[DBO].[PHONE] B
ON A.PHONE = B.PHONE AND
A.FKEY_ID = B.FKEY_ID
WHERE B.PHONE IS NULL AND
A.VALID_END_DATE_TIME IS NULL








Thank you,
Little_Birdie.