Running out, I'm afraid. I haven't used packages deployed to the file system for years. I would guess that there's something going on with .NET versions, but the errors you...

OK, got it!

My next suggestion would be to create a simple script task that does nothing external, eg

int z = 1;

and delete the script component and then try running it...

Deleted

• This reply was modified 2 months ago by  Phil Parkin.

For the current day, what data changes are being made? Inserts, updates, deletes or all three?

Not that it helps you particularly, but the error message indicates that it is a script task which failed, not a script component, which is a different thing.

I would suggest...

That explains it. Copy of an old post with spam link added, perhaps. Thanks!

I have query which is filling TEMPDB

I need suggestion how to modify this query to which can minimize the TEMPDB space to fill

update #TempShow1 set Name = case when...

You misunderstood my suggestion.

Create an...

Build your dynamic SQL statement as an SSIS variable and then, within your ExecuteSQL task, set the SQLSourceType property to 'Variable' and designate your derived SQL variable as the 'SourceVariable'...

Can you at least prove...

Are you saying that you do not know the name of the proc that was executed 27 times (and if so, I'd be interested in knowing what you are looking...

The error message seems clear. The connection from the SQL Server instance to the target server is different from the one from your machine. It could be a networking issue,...

My JSON handling is pretty dodgy, but the following query gets you part of the way.

DECLARE @x NVARCHAR(MAX)
    = N'{
    "metadata":...

I believe the more common, and better, naming for tables is plural.  I can't think of a major relational dbms that uses singular system table names.

For example: sys.objects (SQL...

I agree with the advice given so far, and have a couple more ideas for you to consider.

1. Had you named your tables in the singular (Person, Community), your junction...