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