OK, that makes it more tricky. It should be possible to extract those connection strings into a package-scoped variable, but I think you would need to add a Script Task...

Can you explain the ordering logic, please?

Something like this? It makes a few assumptions about how your data is ordered. What is the PK of this table?

WITH ordered
AS (SELECT a.enddate
   ...

OK, let's assume that the ExecutionMode parameter is set up.

Let's also assume that you have two connection string parameters set up:

ConnectionD and ConnectionM

These are passed into the package at run...

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

Sounds like the trigger has been written in such a way that it accommodates only single-row INSERTs, which is a common problem. It needs...

Somehow when the package runs, it needs to know what 'mode' it's in (monthly or daily).

Consider adding an ExecutionMode (M or D) parameter to the package, which is passed to...

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

OK, got it. You can't do that. Options:

1. Type in the connection string within the Agent job (ie, don't use an environment variable)
2. Create another SSISDB environment containing the different...

Ok, please check table FREE04 for triggers.

There are no subqueries in the code you posted. You must be executing something else as well.

Were you ever able to fix this issue? How did you do it?

I could probably help if I fully understood the question 🙂

Are the following statements true?

1. You have created an environment in SSISDB and associated that environment with multiple projects.
2. You...

xml solution and function solution ex, calling scalar funtion i had . apart from these if any thing is there then pls tell me so that i stop finding...

Hi, this is test data , I am not into working on production & Thanks alot for the answer ,would be nice if you could test too with the...

Do you have a non-Production version of the database that you can test this on? You really need to do that, I think.

How can I ensure for example that rows...

Presumably, you are using SSDT to do the SSIS development? You can deploy from there. You can also deploy using PoSh, which is what I do in our CD environment.

You...