Viewing 15 posts - 16 through 30 (of 42 total)
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...
October 19, 2021 at 4:37 pm
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...
June 22, 2021 at 1:20 pm
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?
June 22, 2021 at 1:14 pm
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...
June 22, 2021 at 12:58 pm
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.
June 22, 2021 at 11:18 am
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]...
June 18, 2021 at 11:54 am
Thank you Steve. Will look into these. Appreciate all the help from everyone 🙂
June 16, 2021 at 11:35 am
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. ...
June 15, 2021 at 7:39 pm
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...
June 14, 2021 at 2:08 pm
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...
May 28, 2021 at 6:16 pm
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...
May 27, 2021 at 12:14 pm
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...
May 27, 2021 at 2:45 am
I also noticed though, if I set the Error Output to ignore truncation errors, I can process the original file as well, but it only imports the first 255 characters,...
May 26, 2021 at 8:44 pm
Thank you again for the response, but unfortunately, setting the "DelayValidation" to True didn't help either.
When I go into Advanced Editor - Input and Output Columns for my Excel Source,...
May 26, 2021 at 8:27 pm
As far as I could tell, I didn't see or notice any bad characters in the records that wouldn't import. I also have the columns set to NVARCHAR(4000) just to...
May 26, 2021 at 6:37 pm
Viewing 15 posts - 16 through 30 (of 42 total)