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...

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...

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...

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 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...

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 may get intermittent error from your application saying " This SqlTransaction has completed; it is no longer usable.". This may have to do with the way connection and transaction are handled in your application. One of the most frequent reasons I...

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...

We sometimes run into scenarios where an application or a windows service running under Local System Account needs to connect to SQL Server and encounter authentication Errors/issues with SQL Server. In SQL Developer support team, we have worked on customer...

My name is Archana CM from Microsoft SQL Developer Support team, we support many data access technologies including Entity Framework, SSIS. I had chance to work with developer who was having issues in his Entity Framework, one of the issue was while adding...

We know that with the default setup of SQL Server (SQL Server 2000/2005/2008), the ‘Default’ instance listens on TCP port 1433. But we have seen that some customers prefer running SQL Server ‘Default’ instance on a TCP Port other...

1. After connecting to SQL Server Integration Services 2005 from SQL Server Management Studio, when you expand MSDB under Stored Packages to see list of stored packages, you may get below error. Failed to retrieve data for this request...

I ran into an interesting situation when executing a Remote Stored Procedure on Linked Server using four part query. Vista-3139 which is a SQL Server 2005 instance is linked to the SERV2003\SQLDUMMY which is a SQL Server 2000 named instance. ...

Guys, I was really excited to find out that Excel 2010 overcomes the limitation of having a maximum number of 255 columns in a worksheet. Personally I always wanted Excel to get around this column limitation while storing data. However, I wanted to share...

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...

Today I am trying to cover a common issue that we face while trying to connect to a remote SSIS service. Sometimes, it happens that when you try to connect to SSIS using SSMS on the machine where SSIS is running and it connects just fine. ...

Linked server in SQL Server 2005 to Sybase ASE 12.5 can be created with both ODBC driver and OLEDB provider. Below are the steps. A. Creating Linked server for Sybase ASE 12.5 from SQL Server using DataDirect Sybase Wire Protocol ODBC driver...

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...

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...

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...

  To know about connection leak you first need to have a basic idea of connection pooling. If you are not sure about connection pooling please visit the following link –: http://msdn.microsoft.com/en-us/library/ms810829.aspx http://msdn.microsoft...

There are scenarios where we may want to add additional methods to an Entity class. When we implement them we have to extend the Entity Data Model Class project by implementing a partial class in our Entity Project. We then create a data service...

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...

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...

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...