Error while trying to create a New SSIS project using BIDS 2008

It’s really intriguing how very minute configurations can have the potential of bringing the entire project development to a grinding halt. In this article, I would like to walk you through one such strange behaviour I noticed on one the Enterprise Customer’s Development Environment. When trying to create a New SSIS package using Business Intelligence…

1

Troubleshooting the SSIS Service Start-up Failure issue

I ran into an interesting situation when one of my customers reported an issue with SSIS service unable to start. The Error message that was displayed when he was attempting to start the start didn’t reveal much information.     When I checked the Event viewer logs, I found the following error message corresponding to…

1

SSMA : Migrate User Defined Data Types from Sybase to SQL Server

SSMA2008 for Sybase doesn’t inherently migrate user defined data type to SQL Server. This applies to the latest build on SSMA for Sybase v4.2.2277. A future version might have the feature to convert them implicitly but as of now we don’t do it.      a) If a Table in Sybase is using a user defined datatype…

2

SQL BULK COPY ERROR (“Operating system error code 5(Access is denied.)”)

  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 doing a bulk copy. For a while now I worked with a…

13

SSMA error ‘External variable cannot be converted’

Today I am blogging about an error that I frequent come across while working on SSMA cases . I tried to search more information about this error in the net but it never returns any useful result. So thought of blogging it. While migrating data from access database to SQL server we sometimes come across…

0

SQL Server Import Export Wizard fails while trying to retrieve the data from Pervasive Database

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 source columns were not mapped correctly to those available on the destination provider.”…

8

Zombie check on Transaction – Error : This SqlTransaction has completed; it is no longer usable.

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 have seen this error showing up in various applications is, sharing SqlConnection across our…

4

Permissions needed to set up linked server with out-of-process provider

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 affect SQL Server process which could also result in crashing SQL server.  To how to…

21

Linked Server Performance (Heterogeneous Databases)

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 were supposed to use Windows active directory for security and…

6

Things to keep in mind regarding Registry while migrating a 32 bit application from Vista x64 to Windows 7 x64

If you are migrating a 32 bit application from Vista x64  to Windows 7 x64 and your application relies on some information in registry. There are few things you should consider as following. In Windows 7, registry is virtualized. As a result, wow64 applications don’t have to explicitly provide registry path with Wow6432Node node. For…

1