I don't think...

I've been working on this package which is a copy of an existing one (tables are different, flat file locations & names are different, but otherwise the packages are...

The (admittedly obscure!) intention of my post was not to criticize your response, but to highlight the fact that in making things dynamic, SSIS slides out of the...

That is true that it doesn't relate to SSIS directly.  My intent with the post was to determine what the end result was and if SSIS could handle it...

If performance is the...

This sounds like it could be handled by linked servers and some dynamic SQL and some fun stored procedures to gather all of the schema level data and compare...

This is an overly cumbersome query. Please explain why everything has to be done in the same code batch.

"This is a business requirement" is not an explanation.

You could do the inserts and updates separately and then just interrogate @@ROWCOUNT ...

SSIS detects nothing.

If a stored proc changes, SSIS will attempt to use the modified version.

If the inputs and outputs to the proc are unchanged, but the internal logic has been...

A new schema? You mean this?

CREATE SCHEMA abc AUTHORIZATION dbo;

That would have no effect whatsoever on existing SSIS packages.

Thank you. So for instance, if I have an SSIS package that is looking at Table1 which has 5 columns in it. Then, when the package runs via scheduling...

The databases have some frequent schema changes such as adding a new schema, or modifying a stored procedure, function or trigger. I forgot to mention the databases also use...

• This reply was modified 6 years, 8 months ago by Phil Parkin.
• This reply was modified 6 years, 8 months ago by Phil Parkin.

Step 1. Use table aliases and consistent query formatting. This is the same query, but notice how much easier it is to begin to see what is happening.