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 4 years 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...

Your syntax is nearly right, but not quite. You will have to explicitly name all of the columns, except for the IDENTITY column, which will take care of itself as...

Is the Id column an IDENTITY column?

That is a statement, not a question. It's similar to me saying: "I am not a turnip".

we tried to upgrade to 2019, but unfortunately, MS has put some restrictions like they have converted scalar functions to inline function by default and that throws an error...