Every get a Cannot insert duplicate key row in object when attempting to merge source and destination via a merge statement when you have specified a match on the unique key fields. More then likely this is caused by nulls in the source and destination key columns. More then likely you specified a unique index … Continue reading
Error at Data Flow Task [SSIS.Pipeline]: “component “Excel Destination” (329)” failed valid To fix this issue. In the Excel connection manager properties you have to set the “DelayValidation” property to TRUE.
[Connection manager “SourceExcel”] Error: SSIS Error Code DTS_E_OLEDB_EXCEL_NOT_SUPPORTED: The Excel Connection Manager is not supported in the 64-bit version of SSIS, as no OLE DB provider is available. When you come across the above error in SSIS while using Excel Connection perform the following action: Go to the property page of the project and … Continue reading
Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerStorageException: An error occurred within the report server database. This may be due to a connection failure, timeout or low disk condition within the database. I ran into this a couple of days ago while attempting to configure a SQL Server 2012 Reporting Services instance. As it turns out the Ops team had configured this … Continue reading