Scott,

Your function works but outputs in rows.

I want like this in fact:

declare @tag varchar(100)

set @tag = 'one-two-three-four'

select 
upper(convert(varchar(10),ltrim(PARSENAME(REPLACE(@tag, '-', '.'), 4)))) as [Post0],
upper(convert(varchar(10),ltrim(PARSENAME(REPLACE(@tag, '-', '.'), 3)))) as...

Scott,

Is it built in function in SQL 2016 SP3?  it doesn't look like it's there.

Msg 208, Level 16, State 1, Line 3
Invalid object name 'DelimitedSplit8K'

Vn

Thanks, Frederico.

The front-end CRM sees exactly what i see on SQL SSMS too.

e.g. O’brien

The CSV file when I open them in Notepad++, they are in UTF-8 encoding, hence they look...

Mark,

The client PCs have no SQL tools at all. I did consider to install just the free SSMS client. But I was refused that request.

May have to go back to...

Hi Jeffrey,

yes, SSRS is a brilliant idea. not sure why it didn't occur to me. I had created few SSRS reports in past.

I will consider SSRS or a python script.

Thank...

Fredrico,

powershell is so restricted and gives me all kind of errors. Scripting is disabled on group policy.

I think I will try python route to access the SP and convert the...

At the moment there is no Data transformation. This is work in progress. Unlikely i may need it, but can't be sure.

I have not done a powershell script before.

Does the...

Hi Fredrico,

The SSIS package calls a SP and outputs the CSV to a network folder. The end users need this CSV for further processing in some other CRM.

A couple of...

Hi Phil,

no, the SSIS is not deployed yet to SSISDB.

Also the client PCs/users will not have any SQL tools on there. I could install basic SQL client (free) on client...

Thank you Phil That works fine now.

Thanks Bradley,

That worked perfectly fine. Apart from an added new prompt for "changes to your device", the Splash and login prompt comes up so quickly.

It was such an annoying thing...

Thank you all for your inputs.

I have resolved the issue using Merge Join (Left Outer join) with Conditional Split (for column = NULL)

which produces exactly the new records I need...

Phil,

Yes, there won't be any duplication in the file within itself because of the unique values(username).

However, regular importing the same CSV file with older data and new data, will make...

Phil,

Yes, there is a unique non-numeric key (username). Can the conditional split be used against one field to check for duplication?

V

Are you saying that the source file contains all the rows (new rows and old rows and is frequently updated with new rows) all the time and that you have...