Archive for

T-SQL Merge Tries to Insert Duplicate Record into table with unique index.

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

SSIS Excel Destination Fails

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.

Excel not Supported in 64bit: DTS_E_OLEDB_EXCEL_NOT_SUPPORTED

  [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

Database Error Thrown Launching SSRS Report Schedules

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