Sqlrelease.com

We have an SSIS 2012 package that supports our internal analytics reporting database by extracting data from an external database server. Last night, for the first time, the package failed due to a database connection timeout error when attempting to...

**My client is unable to sponsor or transfer visas at this time. LOCAL CANDIDATES PREFERRED** A Microsoft End User is seeking a Mid level Microsoft SQL Developer for direct hire. This candidate will have 4+ years of experience with Microsoft SQL Server...

The SSIS Package is loading Excel 2007 file using the MS Access OLEDB driver. ERROR MESSAGE Opening a rowset for "Sheet1$" failed. Check that the object exists in the database. EX_SRC - Excel Generic file source using OLE connector failed validation...

When you have to extract data from an Oracle database SSIS provides the Attunity Source component to do this. In one of my projects we have used this component for year, because it works reliably and really fast. However, after a while we had the new...

Before a couple of days we planned to manual failover of production servers and all live databases for that instance to mirror instance and did a failover too. It was a best experience for failover without fail anything like replication, scheduled jobs...