I get a "Invalid length parameter passed to the LEFT or SUBSTRING function." error plus what if in the number there were a letter like '-16LK5'?

This works most of the time but if I have data like '(t) Jamie Guy -692' it does not:

LEFT(SUBSTRING([AGENT],CHARINDEX(')', [AGENT])+1, LEN([AGENT])-CHARINDEX(')', [AGENT])),LEN([AGENT])-10)

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

What about a different datatype in SQL... Blob or Html? Would the text shown go into that?

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

I was able to get the package to run but the csv is proving to be useless since it inspite of being 1020 chars in the SQL table it cuts...

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, 11 months ago by DaveBriCam.
• This reply was modified 4 years, 11 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: