I would:

• Create a log table
• Insert all jobs into it
• Create a proc to check for any jobs not in the log table

  • if it finds anything, insert the...

Imagine a 2 inch pipe that you are trying to use for dumping waste from your house.  😉  That size pipe is way too small and will actually result in...

Have you tried splitting your input stream?  This technique really speeds up the load.

Es posible que desee considerar la sintaxis obsoleta y los niveles de compatibilidad de la base de datos. Por ejemplo, puede establecer el nivel de compatibilidad de una base de...

Before making any data change, I backup the table.  Always - no matter how "trivial" the change.  I keep these table backups for a period of time before dropping them.

I...

It has also been my experience that it is more challenging to track errors down to their sources with the Integration Services Catalog when using child packages.  I have done...

I would look at the SQL coming in to SQL Server to understand what is happening.

Wow, this is interesting!  First, it seems like you are dealing with an unusually large number of .rdls for a given business requirement.  That could be a design flaw.  Next,...

This is a tough post to follow, but I have one idea that may help.  Have you investigated role-playing dimensions?  This concept may be helpful and should eliminate the need...

Great question!! I can't stress enough the importance of you learning this.  There are lots of materials you can find and they are worth your time.  A good developer should...

I had to learn it for an exam and that is the only time I've used it 😉

If you don't mind sharing...what is the business requirement you are trying to...

I've not has a business requirement for this so I haven't done this yet.  However, I'm wondering if dynamic SQL would work.  Have you tried that?

Hey Jeff.  Great idea!  I'm going to add this to my notes.

When you have a new historical period, you create a new table and modify the view definition?

I think using a child package like this may not be the best performing idea, but here is how you could do it.

First, in the master package, have an Data...

Hey Alex.  Can you give me the DDL for dbo.PROP_X_CAND_AVAIL and [A00].[ReferralAnonymousRequest]?