A bigger problem is I'm finding it hard to identify where the errors are occuring... the red dot is over the source file when I run the package. The error...

Thanks! This appears to be running at least 50% faster than the MERGE

Like this? Note the syntax problems:

BEGIN

INSERT a2wh.dbo.CallLogCommon_dbc D

(D.[CALL_ID],
D.[DATE],
D.[TIME],
D.[lead_id],
D.[DOMAIN], 
D.[SESSION_ID],
D.[CALL_TYPE],
D.[CALLS],
D.[CAMPAIGN],
D.[LIST_NAME],
D.[CAMPAIGN_TYPE],
D.[SKILL],
D.[CUSTOMER_NAME],
D.[DISPOSITION]) --DOES NOT LIKE THE ")" SYNTAX

SELECT

(S.[CALL_ID], --DOES NOT LIKE THE COMMA SYNTAX
S.[DATE],
S.[TIME],
S.[lead_id],
S.[DOMAIN], 
S.[SESSION_ID],
S.[CALL_TYPE],
S.[CALLS],
S.[CAMPAIGN],
S.[LIST_NAME],
S.[CAMPAIGN_TYPE],
S.[SKILL],
S.[CUSTOMER_NAME],
S.[DISPOSITION])

FROM F905.dbo.stgCallLogCommon_dbc S

WHERE NOT EXISTS (SELECT...

I'm hoping this will work:

MERGE a2wh.dbo.CallLogCommon_dbc AS TARGET

USING F905.dbo.stgCallLogCommon_dbc AS SOURCE

ON TARGET.[CALL_ID] = SOURCE.[CALL_ID] AND 
TARGET.[DATE] = SOURCE.[DATE] AND
TARGET.[DOMAIN] = SOURCE.[DOMAIN] AND
TARGET.[CALL_TYPE] = SOURCE.[CALL_TYPE] AND
TARGET.[TIME] = SOURCE.[TIME]

WHEN...

Did an uninstall/reinstall of SSDT. Still can't see or edit my C# script. I uninstalled VS. What is the best link to reinstall VS & SSDT?

One more issue arose. I cannot edit my C# Scripts... I hit the button and C# won't launch... I ran the repair on VS 17 and restarted my machine and...

The link you supplied worked with no problems.... thanks!

I had to uninstall everything to clean things up. Should I install VS before the link you posted?

Visual Studio 17 Microsoft SQL Server Data Tools for Visual Studio 2017 SSDT Version 15.9.30

I don't remember installing any extensions, but I may have, all I know is it was...

• This reply was modified 4 years, 3 months ago by DaveBriCam.
• This reply was modified 4 years, 3 months ago by DaveBriCam.

Right clicking does not give me an option of View Designer

I have SSDT open but I don't know from there what to open. I see a solution .sln file but when I open it here's what I see: 

This idea worked... and is simple... thanks!

I'm getting this error from the CTE solution (which is on the right track I think): Column 'cte.DOMAIN' is invalid in the select list because it is not contained in...

Crisis avoided I restored a previous version.

There probably are now as my original package corrupted and I had to make a copy. I'm trying to create a flat file connection manager and have for gotten how...