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:

            
March 19, 2020 at 7:12 pm
            
#3735683

            
            
                                                
        

You may be interested in using the CONCAT() function – it's tidier (IMO) than all those plus signs, does datatype conversion and handles NULLs for you.

Also note that you...

Jeff, these may be for you (if you dare venture anywhere to buy them, that is!). I have a pair and they work a treat. Not that I don't...

Does this get you anywhere close?

WITH ColumnInfo
AS (SELECT Sch = SCHEMA_NAME(t.schema_id)
          ,TableName = t.name
    ...

That's why I'm asking people to write a...

Spaces at the end of strings are usually ignored by SQL Server. Have a read here for some more detail.

--Neil beat me to it!

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