This is a very generic error and can occur due to multiple reasons. I am documenting as much as of them based on Case studies. Refer to the description and the error codes for each of the unique errors. A: Error: "DTS_E_OLEDBERROR. An...

When setting up linked server to third-party Databases, it is recommended to run the third-party provider in out-of-process mode, because when the provider is run in-process (within the same process as SQL Server), then any issues with the provider can...

A .NET Framework error occurred during execution of user-defined routine or aggregate "deploy_project_internal": System.ComponentModel.Win32Exception: A required privilege is not held by the client. I ran across this issue in one of my newly...

Folks, yet another stumble with SSIS and Excel. This time I am using Microsoft Office 11.0 Object Library. The code runs fine on Windows Server 2003. Below is the code sample. ======================================================= using Microsoft.Office...

Intermittent connectivity issues from a client machine when connecting to a remote database server can be often attributed to the network layer. By collecting the network traces and reviewing them we can tell why the connections failed to succeed or if...

This is one of the most common errors while creating linked server to Oracle database. Today I will discuss the reason for this error and possible resolutions. Full error message: OLE DB provider "MSDAORA" for linked server "LINKED_ORA...

Folks, I wanted to post this experience as I struggled for a couple of days trying to figure out what’s wrong in my connection string when I handled a migration scenario from Windows 2000 to Windows 2008. I had a bunch of VBScripts doing database...

While there are various forms of bulk copy this blog specifically deals with copying data from a file into SQL Server. It deals about the specific error “Operating system error code 5(Access is denied.)” which might crop up under certain circumstances...

When you try to develop an SSIS package in x64 Environment in BIDS that connects to a Oracle Database, you will invariably run into connectivity issues if the installed Oracle Client tools version is 10.2.0.1 (x86). You will obviously need to install...

In this blog, I have attempted to answer some common questions we have seen on Sync framework (and Sync services for ADO .Net) while working with our customers on Sync framework issues. After working with multiple versions of Sync Framework and Sync Services...

Holiday season provides us an opportunity to take a break from our hectic schedules in GTSC and ponder over some interesting cases in past few months. I had been a strong believer in the fact that a lot of bugs attributed to Microsoft are not Microsoft’s...

Before we could begin our Data Migration, you’ll need to clearly understand what is UTF8 is the 8-bit encoding of Unicode? It is a variable-width encoding and a strict superset of ASCII. This means that each and every character in the ASCII character...

In one of my previous blogs I tried to summarize the roadblocks and the ways to address them when a SSIS Package talks with Oracle Database. Apart from the Oracle Network Bug (Fixed in Oracle Client Tools version 10.0.0.3 and above), I faced another roadblock...

Folks, in my continued experimentation with SSIS and Excel I found out another roadblock which is typically permission related and want to highlight the same in this post. This time I used the script task to read and save an Excel (.xls) document using...

Today I am going to blog about a frequent issue that we come across while creating linked server-: Cannot create an instance of OLE DB provider "MSDADASQL" for linked server "MyDB2" In this scenario I was creating a linked server to a DB2 server...

When trying to import data from Pervasive DB to SQL Server 2008 DB using import/ export wizard we get the following error message :- "Column information for the source and the destination data could not be retrieved, or the data types of...

I hope you probably know how to fix below different authentication related errors that can occur while connecting to SQL Server with Windows Integrated Authentication. 1. Login failed for user '( null) '. Reason: Not associated with a trusted...

Last week I thought I should migrate my SQL CE 3.5 sample applications connecting and opening a Sql Compact Edition Database from Windows Server 2003 to Windows 7. In fact, I tried migrating them both to Win 7 and Win 2008 R2 and straight away ran into...

In this blog I will discuss about how to consume a Web Service in the Script Task of a SSIS package. To consume web methods in SSIS script task you need to follow the following steps: Create a Proxy Class of a Published Web Service ...

You might get the following error when there is any issue related to a SPN in the environment: 1) Login failed for user ‘null’ 2) Login failed for user ‘’ 3) Login failed for user 'NT Authority\Anonymous Logon‘ ...

Recently I was working on a problem where the scenario was as below. There are various applications connecting to SQL Server to fetch data. But the actual data was not resident on the SQL Server rather on Oracle 10g and IBM DB2 Databases. The applications...

I recently had an issue where after the installation of a Third party Client side tools, we were not able view the drivers listed in the ODBC Data Source Administrator (odbcad32.exe). In order to create a DSN to use this third party driver, we had...

This post describes an interesting scenario that I came across when working with a SSIS package developer. The main issue was that we were unable to run the SSIS package that contains a execute process task calling a batch file stored on a remote server...

SQL Server 2008 and SQL Server 2008 R2 (Enterprise editions) support bulk loading Oracle data using Integration Services packages with the Microsoft Connector for Oracle by Attunity. For SQL Server 2005 and the non-Enterprise editions of SQL Server 2008...

When we create linked server for SQL server 2000 on SQL server 2005/SQL server 2008 /SQL server 2008 R2 sometimes we see errors w.r.t schema. In this blog, I will discuss on why we get this type of error and also the solution to fix the error message...