Our packages are randomly failing with the following error message: > SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: > 0x8004D00A. COM error object information is available. Source: "[Some Package > Name]" error code: 0x8004D00A Description: "The SSIS Runtime has failed to > enlist the OLE [...] read more
I am in DataGrid hell right now but that's another post. Anyway, I wrote a view with a union query in SQL Server that grabs data from a linked SQL server. Anytime I try to add this object as a dataset in VB.NET it completely bombs out on me with [...] read more
We have been successfully copying data from a MySQL Slave database into a MSSQL database. The MySQL server is a linked server. I have tried using v3.51 and v5.1.8 of the ODBC connector provided my MySQL. Simply trying to insert into a temporary table in MSSQL from a table in [...] read more
I have a Business Objects Web Intelligence report that is performing a distributed query against two databases. When I run this query that includes a BEGIN DISTRIBUTED TRANSACTION QUERY SET xact_abort ON GO USE Pipeline2 GO BEGIN DISTRIBUTED TRANSACTION SELECT * FROM [CQSR_PROD].CqUSer.Cq4User1.Defect COMMIT TRAN GO I get this error: [...] read more