Share via


SQL BI / Data Access Technologies

( SSIS, SSRS, SSAS, Data Access, POWER BI, PBI RS, Azure AS, SSMA, LINQ, System.Data ... )

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

Author: Snehadeep Date: 12/14/2010

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

Author: Snehadeep Date: 12/14/2010

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

Author: Snehadeep Date: 11/09/2010

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

Author: Snehadeep Date: 10/29/2010

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

Author: Snehadeep Date: 10/20/2010

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

Author: Snehadeep Date: 09/09/2010

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

Author: Snehadeep Date: 08/24/2010

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

Author: Snehadeep Date: 08/19/2010

Linked Server Performance (Heterogeneous Databases)

Recently I was working on a problem where the scenario was as below. There are various applications...

Author: Snehadeep Date: 06/30/2010

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

Author: Snehadeep Date: 06/30/2010

Issue with Microsoft Connector v1.0 by Attunity with Teradata

Recently I was trying out the SSIS connector for Teradata by Attunity in one of my sample SSIS...

Author: Snehadeep Date: 06/18/2010

LINQ query where dynamic values does not reach correctly to the generated TSQL

Recently we came across an interesting LINQ issue where we are trying to find out number of...

Author: Snehadeep Date: 05/28/2010

Why is my ConnectionString incorrect..?

Folks, I wanted to post this experience as I struggled for a couple of days trying to figure out...

Author: Snehadeep Date: 05/28/2010

Write method of OpenSQLFileStream is generating Event 2000 Errors on SQL Server

One of my customers was experiencing a lot of event 2000 errors on the SQL Server Machine. These...

Author: Snehadeep Date: 05/13/2010

Issue with SQL CE bulk record deletion if proper indexes are missing in the referenced tables

Recently we worked on a SQL CE issue where bulk deletion of the record in the table was taking...

Author: Snehadeep Date: 04/30/2010

Configuring Attunity Connector to Bulk Insert Data to Oracle using SSIS

Microsoft Connector for Oracle by Attunity offers high speed connectors for Oracle to bulk insert...

Author: Snehadeep Date: 04/12/2010

Enterprise Library 4.1 DAB leaking oracle connections that participate in DTC transactions

We had a case recently where connection pooling was not happening properly when using Enterprise...

Author: Snehadeep Date: 04/07/2010

Issue with the sync framework if Batching is enabled

A few weeks back I was working on sync framework issue which i found worth blogging, we were using...

Author: Snehadeep Date: 03/30/2010

Overcome Error “The metadata store replica is already in use” while doing a File Sync

While doing a file Sync we may see error that the metadata store replica is already in use. This...

Author: Snehadeep Date: 03/30/2010

Unable to execute a remote stored procedure over a linked server

I ran into an interesting situation when executing a Remote Stored Procedure on Linked Server using...

Author: Snehadeep Date: 03/30/2010

How best to connect to a default instance of SQL Server listening on a non-standard port with a firewall enabled.

We had a case recently where the Default instance of SQL Server was listening on a non-default port....

Author: Snehadeep Date: 03/10/2010

SSIS can sometime throw error “Execution was canceled by user” when there is a issue with the DTS package task.

Recently I was working with the legacy Execute DTS 2000 Package Task in SSIS and found that In the...

Author: Snehadeep Date: 03/09/2010

Running SQL Server ‘Default’ instance on a non-default (or non-standard) TCP port: : tips for making application connectivity work

We know that with the default setup of SQL Server (SQL Server 2000/2005/2008), the...

Author: Snehadeep Date: 03/03/2010

Java two tier applications will show connection leak symptoms with Microsoft SQL JDBC driver when running outside of a Web Server or Web Container

Java two tier applications running outside a java web server or java web container using SQL Server...

Author: Snehadeep Date: 02/26/2010

Testing connection to SQL Server from a service running under Local System Account

We sometimes run into scenarios where an application or a windows service running under Local System...

Author: Snehadeep Date: 01/29/2010

Consuming Web Services in SSIS Script Task

In this blog I will discuss about how to consume a Web Service in the Script Task of a SSIS package....

Author: Snehadeep Date: 01/28/2010

Connecting to remote SQL Server Integration Service from SQL Server management Studio

Today I am trying to cover a common issue that we face while trying to connect to a remote SSIS...

Author: Snehadeep Date: 01/28/2010

SQL CE and IIS 7.5 Issue: SqlCEException: The operating system does not support the Encryption Mode provided

Last week I thought I should migrate my SQL CE 3.5 sample applications connecting and opening a Sql...

Author: Snehadeep Date: 01/26/2010

Connectivity Issue with Oracle in x64 Environment “ORA-12154: TNS:could not resolve the connect identifier specified”

When you try to develop an SSIS package in x64 Environment in BIDS that connects to a Oracle...

Author: Snehadeep Date: 01/26/2010

Who takes care of my database connection when I don’t close it in my code?

A lot of customer has asked me a common question : How should I expect my connections to behave if I...

Author: Snehadeep Date: 01/08/2010

How to grant ReadServicePrincipalName and WriteServicePrincipalName rights to SQL Server service start-up account without using ADSDIEDIT tool.

I hope you probably know how to fix below different authentication related errors that can occur...

Author: Snehadeep Date: 01/06/2010

The SSIS and Oracle Story Continued…

In one of my previous blogs I tried to summarize the roadblocks and the ways to address them when a...

Author: Snehadeep Date: 12/28/2009

SSIS 2008 now talks to SAP BI Database..

Microsoft now offers a connector for SAP BI in Sql 2008 Integration Services (Enterprise and...

Author: Snehadeep Date: 12/28/2009

SSIS 2008 now talks to Teradata Server as well!!

I was trying out the high speed connectors offered by Attunity which enables SSIS Packages to talk...

Author: Snehadeep Date: 12/28/2009

How to log ODBC DSN changes

There is often a challenge to determine the last user who changed the ODBC DSN and when these...

Author: Snehadeep Date: 12/14/2009

You get error code “DTS_E_PRODUCTLEVELTOLOW” while running package outside Business Intelligence Development Studio

Error: "Product level is insufficient" Or “The task ......cannot run on this edition of...

Author: Snehadeep Date: 12/10/2009

Way to Expose Custom method in an Entity class from WCF Data Service

There are scenarios where we may want to add additional methods to an Entity class. When we...

Author: Snehadeep Date: 11/30/2009

How to create a linked server in SQL Server 2005 for Sybase ASE 12.5 database using DataDirect's ODBC Driver and OLEDB provider?

Linked server in SQL Server 2005 to Sybase ASE 12.5 can be created with both ODBC driver and OLEDB...

Author: Snehadeep Date: 11/12/2009

MSDB and File System doesn't appear under Stored Packages, After connecting to SQL Server Integration Services 2005 from SQL Server Management Studio

Cause and Resolution SSIS uses the value of Registry key...

Author: Snehadeep Date: 11/12/2009

SSIS error “Failed to retrieve data for this request”: reasons and resolutions

  1. After connecting to SQL Server Integration Services 2005 from SQL Server Management Studio, when...

Author: Snehadeep Date: 11/12/2009

SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred :- Reasons and troubleshooting.

This is a very generic error and can occur due to multiple reasons. I am documenting as much as of...

Author: Snehadeep Date: 11/09/2009

Application may fail with buffer size error when we move the SQL Server CE database between Desktop Windows OS and WM/WCE.

Symptoms If we move the SQL Server CE database from one platform to another platform, the...

Author: Snehadeep Date: 10/27/2009

Parsing larger XML file using “sp_OACreate” returns incorrect values

sp_OACreate is a way to instantiate OLE / COM objects inside of SQL Server in the MemToLeave area of...

Author: Snehadeep Date: 10/23/2009

You get an error when you attempts to save SSIS packages to the MSDB package store if the network packet size >=16388 Bytes

In SQL Server 2005 if you configure network packet size to 16388 or greater, and attempts to save...

Author: Snehadeep Date: 10/16/2009

Who owns my job and who runs it?

There has usually been confusion over who owns the SQL Agent job and who runs executes the steps....

Author: Snehadeep Date: 10/13/2009

Connection leak , its symptoms and troubleshooting

  To know about connection leak you first need to have a basic idea of connection pooling. If...

Author: Snehadeep Date: 10/13/2009

<Previous Next>