If the file name is "ImportFile_UK_DumpXX_20220501", what exactly do you want the expression to return?

If FileCode <> 1, what do you want the expression to return?

Yes, I agree that a Foreach loop (FEL) with an object variable sounds like the way to go.

Is there really a direct mapping between the package names and the table...

ON (1 =1) is unusual JOIN syntax – can you explain what you want it to do?

I have some ideas – they involve GROUP BY and MAX(). You have nearly 4,000 points and this is simple stuff. What have you tried so far?

Please complete the following VALUES section code to give us your test data to work with:

DROP TABLE IF EXISTS #SomeTab;

CREATE TABLE #SomeTab
(
    Id INT...

Not very elegant, but I think that this works:

WITH c1
AS (SELECT *
          ,Ctr = IIF(conversion_factor IS NULL, 0,...

Here is that link again: https://www.sqlservercentral.com/articles/forum-etiquette-how-to-post-datacode-on-a-forum-to-get-the-best-help

Envreference should be a number, I think. Here is an example from MS:

DTExec /ISSERVER "\SSISDB\folderB\Integration Services Project17\Package.dtsx" /SERVER "." /Envreference 2 /Par "$Project::ProjectParameter(Int32)";1 /Par "Parameter(Int32)";21 /Par "CM.sqlcldb2.SSIS_repro.InitialCatalog";ssisdb...

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

Executing an SSIS package from T-SQL is straightforward, see link.

10-15 rules at this point...yes we would like a UI for BEU to make changes to the different rules..

Have any good examples of how to accomplish based on requirements...

This is a far better idea than mine!

I do not think that this is possible. If you check the documentation for filtered indexes (link), you will find the following limitation:

Filtered indexes are defined on one table...

Can you tell us more about the nature of the 'training platform'? Do you have direct access to a database for this platform?

Also, what do you mean by 'sent to'?...

We enabled / created SSISDB in one of our non-prod environments before we discovered we aren't allowed to use SSISDB on our servers (long story, don't ask). Now I'm...

Errors which happen as data is loaded into a physical table often result in unhelpful error messages in SSIS.

As a first step, I would try to determine one or more...