I have not thought about that, I was just going by record counts shown for each table.  I will look into this and see if I can find anything along...

Phil:

I understand and just very appreciative of all the help you always provide.

Phil:

After playing with that query, I notice it gives me all the "Step_Names" as being "(Job Outcome)" and the Job_Descriptions are all of the job itself, but not the step...

• This reply was modified 3 years, 1 month ago by  AMCiti.

Michael:

Thank you for the suggestion, but unfortunately this brings back all jobs that failed regardless of the date, so it will show the last time a job failed, even if...

Phil:

That might be the problem.  I don't have access to install anything on my PC due to security and need to "request" software through our software procurement procedure.  They probably...

Phil:

Isn't that the same as the Microsoft Access Database Engine 2010 (English) 14.0.7015.1000 that is shown in my Add / Remove programs panel?

Phil:

The issue is that when I try to import *.xlsx files using either SSIS / SSMS (Import Data option), I get the error "Microsoft.ACE.OLEDB.12.0 Provider Is Not Registered" / "Microsoft.ACE.OLEDB.16.0...

You are correct.  I only have the 32-bit DTExec installed.  I am having an issue though finding how to install the 64-bit version of this.

Here is the table with the historical record counts:

CREATE TABLE [dbo].[HistoricalRecordCounts](
[ID] [int] IDENTITY(1,1) NOT NULL,
[DatabaseName] [nvarchar](255) NOT NULL,
[SchemaName] [nvarchar](255) NOT NULL,
[TableName] [nvarchar](255) NOT NULL,
[RecordCount] [int] NOT NULL,
[ReportDate]...

Thank you Steve.  Will look into these.  Appreciate all the help from everyone 🙂

All:

Thank you for the help, but I have been told the way these tables are populated, adding a "Date Added" or any other column to the tables is not possible. ...

Thom A:

That makes sense and we have thought about going down that path, but was hoping perhaps we could do it with a query against some system tables without the...

I had a random thought on this, in that I can sort my query to the Excel file by the LEN() of the field causing the issue such as:  SELECT...

Phil:  thank you for taking the time to try.  I appreciate it immensely.

Jeff:  thank you for all your help as well.  I cannot thank you enough for the time and...

Thanks for the information.  I do appreciate it.  One thought I had, but I am not sure how to go about executing it, or if it would even work.  In...