That is kind of what I thought. The packages are not for production, they are for development, so I guess that is one possible path. I just was hoping there...

The difference would be positive vs negative.  The issue I am running into is that I am wanting to have an on time status for each individual record, not just...

This is what I am using

I'm guessing you're talking about a database modeling or entity relationship diagram (ERD) tool. I don't know of an extension for SSMS or...

Where would I set up those parameters? Do you mean just using like a magic string in the Connection string and then doing something after deploying?

• This reply was modified 5 years, 6 months ago by  Steven.Grzybowski.

Jeff, under normal circumstances I would agree, The issue is that the table is a massive table that is updated frequently by the application, so our normal audit tools just...

Turns out that it was just that I was using a non-unique value for the Rows.

After doing some more digging in msdb.dbo.sysjobhistory I see that the jobs that are run by the process are running multiple times.  The for each loop  is fed from a data...

After splitting things out into temp tables before attempting to do the big calculations, I discovered that the data in the semi-colon delimited fields was not actually usable, as a...