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 3 years, 7 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...

The best-practice way of doing such things is first to create and populate a generic calendar table. This could contain columns such as

Date, Year, Month, Day, Quarter, Week, MonthName, DayName

and...

This is, as I am sure you are aware, also quite heavily dependent on the...

This is, as I am sure you are aware, also quite heavily dependent on the...

Doing it this way may help. It assumes that twdatum is a datetime column and that there is a suitable index in place (eg, on (twdatum, asis)).

DECLARE...

Try changing ELSE 0 to ELSE NULL.

Otherwise you are just counting zeros rather than ones, which explains the behaviour you are seeing.

Runs fine for me. Maybe now you appreciate that different flavours of SQL have their...

Here's another version.

DROP TABLE IF EXISTS #t;

CREATE TABLE #t
(
    Part INT NOT NULL
   ,lowest_cost DECIMAL(19, 6) NOT NULL
   ,date_received DATE...