Showing posts with label Error. Show all posts
Showing posts with label Error. Show all posts
Saturday, October 21, 2017

Microsoft Access Database Engine 2016 Redistributable Setup - You cannot install the 32-bit version, You cannot install the 64-bit version

›
In order to access Excel workbook using Integration Services, one component we need to install is Microsoft Access Database Engine 2016 Re...
1 comment:
Monday, July 31, 2017

SQL Server bcp error - String data, right truncation

›
We generally expect a proper row terminator with files loaded using bcp  and with all accurately defined switches, data should be loaded w...
Friday, June 2, 2017

Power BI does not show all columns in SQL Server View

›
I experienced a strange issue with Power BI today, I might have missed something or there is something unknown to me. This is what I exper...
Monday, May 15, 2017

Reporting Services - An error occurred within the report server database....Database 'ReportServerTempDB' cannot be opened

›
Yesterday, I posted on an error related to Reporting Services. Here is another error related to Reporting Services encountered at one of m...
Sunday, May 14, 2017

Reporting Services - HTTP Error 404. The requested resource is not found.

›
What if you suddenly experience this when you open the Reporting Services Portal? HTTP Error 404. The requested resource is not found....
3 comments:
Friday, February 10, 2017

SQL Server Data Tools (Visual Studio) - The length of the full path for the solution, project or item you are creating exceeds the maximum path length allowed

›
While trying to create a new SSIS project with default values for Project Name, Location and Solution Name , I experienced the following l...
Friday, December 30, 2016

Inserting records, ignoring duplicates, recording them

›
A column like email address  in en entity like Customer or Employee is always set with an UNIQUE Constraint  to make sure that no duplica...
Wednesday, December 28, 2016

Reporting Services (SSRS) 2016 - Could not load folder contents Error - Even with SP1

›
I have been continuously hitting with this when the Reporting Services portal is opened first time; Could not load folders contents ...
3 comments:
Wednesday, December 14, 2016

Management Studio Error: The Visual Studio component cache is out of date. Please restart Visual Studio.

›
I experienced this error when opening Management Studio just after the installation of Windows update. Not sure about the reason b...
2 comments:
Friday, November 25, 2016

SSIS OLE DB Destination sends all records to Error Output

›
SSIS OLE DB Destination is one of the destinations we heavily used for loading data to databases. Generally we used Data access mode - fas...
Thursday, November 24, 2016

SSIS Exception deserializing the package The process cannot access the file .ispac because it is being used by another process

›
For some reasons, my  SQL Server Data Tools were crashing on a specific package and I could not get it up and running after that until I r...
Thursday, September 22, 2016

Cannot execute as the database principal because the principal does not exist - Mismatched Security IDs

›
Are you experiencing this error with newly restored database? Cannot execute as the database principal because the principal "abc...
Saturday, August 6, 2016

The shared dataset definition is not valid. Details: The required attribute 'Name' is missing

›
Are you experiencing this error when trying to deploy a shared dataset?  This has been mentioned in several forums and considered ...
Wednesday, August 3, 2016

Arithmetic overflow error converting expression to data type int - It works for larger number but not for a smaller number

›
One of my colleagues sent me a simple code that has two lines. The first line works without any issue but second throws an error. This is ...
Saturday, July 2, 2016

Connecting to the Integration Services - "Access is denied."

›
If required permissions are not configured for Integration Services for your account, you will experience following error when trying to c...