OK, so my code should work, with some refinements to handle the zeros.

DECLARE @DateStr NVARCHAR(50) = N'12172019';
SELECT @DateStr,
    CAST(CONCAT(RIGHT(@DateStr, 4), LEFT(@DateStr, 2), SUBSTRING(@DateStr, 3, 2)) AS DATE);

• This reply was modified 6 years, 6 months ago by Phil Parkin.

"Not working" is not helpful. What is the error message?

NVARCHAR needs a length.

What is the data type of [due date]? If it's a date, why not just

CAST([due date]...

"Not working" is not helpful. What is the error message?

NVARCHAR needs a length.

What is the data type of [due date]? If it's a date, why not just

CAST([due date] as DATE)

?

Here's a native version, in case you'd prefer that.

DECLARE @MinDate DATE =
        (
       ...

As you are loading multiple files, are you concerned about the order in which they are loaded?

Have you checked the All Executions report to look for clues as to the error?

Are you sure that this is an execution error and not an initial validation error?

Does the...

Add an OLEDB source, with suitable connection.

Set Data Access mode to SQL Command.

In SQL command text, add the command to execute your stored proc: EXEC dbo.SomeProc

(If your proc selects its...

You are right: two data flows will be required.

OK, you need to do that differently.

You'll need to create a data flow. Inside the data flow, create two data sources, one which selects from the stage table and one...

To truncate a table or exec a stored proc , use an ExecuteSQL task.

With >7000 points, how can you claim to be "new to SQL Server"?

Please attempt your own explanation... then we can check it for you.

Btw, w.t.heck does H stand for in that "name" anyway??

That is my mistake! For some reason, I had the word 'hyphen' in my mind when I wrote the code, and...

I'd make it less cluttered by using a variable for the literal single quote:

DECLARE @H CHAR(1) = '''';

the CONCAT version then becomes something like this: