SQL BI / Data Access Technologies
( SSIS, SSRS, SSAS, Data Access, POWER BI, PBI RS, Azure AS, SSMA, LINQ, System.Data ... )
UNVIPOT TRANSFORMATION WITH A COMBINATION OF SINGLE AND MULTIPLE DESTINATION COLUMNS
It is highly not uncommon that while using Unpivot Transformation in SSIS you feel the need to...
Author: Snehadeep Date: 05/21/2014
SSIS package fails with error : The step did not generate any output. The return value was unknown
One of my customers recently ran into a very strange issue. We had many SSIS Packages that were...
Author: Snehadeep Date: 05/21/2014
SQLAllocHandle on SQL_HANDLE_HENV, from Linux SQLNCLI driver
While connecting to SQL from client application(running on linux server), using using ‘SQL...
Author: Snehadeep Date: 01/22/2014
tmp_ms_ getting appended in temp table while creating deployment script from SSDT
I am Sandeep Chalke from Microsoft Data Access Support Team. My team deals with issues that arise...
Author: Snehadeep Date: 01/22/2014
SSIS Package implementation programmatically
It’s Simple to develop SSIS package using BIDS, but in this blog I am concentrating on how to...
Author: Snehadeep Date: 11/26/2013
Single quote is appended to all strings when data is transformed to excel when using Excel destination data flow component in SSIS package.
In this blog, I am going to discuss on the issue that one might face while transferring data from...
Author: Snehadeep Date: 10/07/2013
SSIS 2012 Automation – Part 3: Create SQL Agent Job which will execute SSIS package from SSIS catalog, Assign Environment Reference and Assign Schedule to Job
This third and last part of automation blog, SSIS 2012 Automation – Part 1: Deploy SSIS Project to...
Author: Snehadeep Date: 10/07/2013
SSIS 2012 Automation – Part 2: Create environment, map it to project and package level parameters and assign reference to project
This blog is in continuation of SSIS 2012 Automation – Part 1: Deploy SSIS Project to SSIS Catalog...
Author: Snehadeep Date: 10/07/2013
SSIS 2012 Automation – Part 1: Deploy SSIS Project to SSIS Catalog
I recently ran into few cases where customer needed to automate SSIS Project configuration and job...
Author: Snehadeep Date: 10/07/2013
System.ComponentModel.Win32Exception: A required privilege is not held by the client while Deploying SSIS Project
My name is Archana CM from Microsoft SQL Developer Support team, we support SQL Connectivity issue...
Author: Snehadeep Date: 08/20/2013
ImplicitCommitSync property not working for Access DSN
My name is Archana CM from Microsoft SQL Developer Support team, we support SQL Connectivity issue...
Author: Snehadeep Date: 08/20/2013
Flat File source cannot handle file with uneven number of columns in each row
I hope not many people are using flat file with such kind of structure, but if you are then no...
Author: Snehadeep Date: 03/13/2013
Lookup Transform Error: Row yielded no match during lookup
Guys, Recently, I had to implement a lot of data warehousing solutions, hence I stumbled on an error...
Author: Snehadeep Date: 03/13/2013
"Cursor operation conflict" error while inserting data from flat file source to OLEDB destination
I was working on one of the issue related with SSIS OLEDB destination editor. Here is the scenario....
Author: Snehadeep Date: 03/05/2013
Integration services packages using Execute process task with WinZip32.exe fails intermittently, when run under a SQL Server Agent Job:
This blog is about one of the known issues that anyone would run into when executing an Integration...
Author: Snehadeep Date: 03/04/2013
Leveraging a Hadoop cluster from SQL Server Integration Services (SSIS)
With the explosion of data, the open source Apache™ Hadoop™ Framework is gaining traction thanks to...
Author: Snehadeep Date: 12/19/2012
Openrowset and FoxPro Database
I wanted to write about one of my experiences where I nearly pulled off my hair while trying to make...
Author: Snehadeep Date: 12/19/2012
Error Message "Login failed. The login is from an untrusted domain and cannot be used with Windows authentication."
My name is Archana CM from Microsoft SQL Developer Support team, we support SQL Connectivity issue...
Author: Snehadeep Date: 12/19/2012
Could not load package because of error 0x80070002 while upgrading from SSIS 2008 to SSIS 2012
When doing an In-place upgrade from Microsoft SQL Server 2008 or 2008 R2 to SQL Server 2012, be...
Author: Snehadeep Date: 09/28/2012
Syntax error, permission violation, or other nonspecific error
While developing a package in BIDS 2008 if we use SNAC 10.0 driver in OLE DB Source connection, call...
Author: Snehadeep Date: 08/20/2012
Error While Deploying SSIS 2012 project from SSDT to SSIS Catalog : System.ComponentModel.Win32Exception: A required privilege is not held by the client
A .NET Framework error occurred during execution of user-defined routine or aggregate...
Author: Snehadeep Date: 08/20/2012
Migrating UTF8 data from Oracle to SQL Server using SSMA for Oracle
Before we could begin our Data Migration, you’ll need to clearly understand what is UTF8 is the...
Author: Snehadeep Date: 08/09/2012
Error: "The underlying provider failed on Open" in Entity Framework application
My name is Archana CM from Microsoft SQL Developer Support team, we support many data access...
Author: Snehadeep Date: 08/09/2012
Error while creating Linked server "Cannot obtain the schema rowset "DBSCHEMA_TABLES_INFO" for OLE DB provider "SQLNCLI10" for linked server ‘LinkedServerName’"
When we create linked server for SQL server 2000 on SQL server 2005/SQL server 2008 /SQL server 2008...
Author: Snehadeep Date: 08/09/2012
Optimized Bulk Loading of Data into Oracle
SQL Server 2008 and SQL Server 2008 R2 (Enterprise editions) support bulk loading Oracle data using...
Author: Snehadeep Date: 04/11/2012
SSIS: Error 0x80070020 Unable to access the package file. Make sure the file exists and you have permission to access it.. The process cannot access the file because it is being used by another process.
This is my second blog and it is about a very interesting scenario that I came across when working...
Author: Snehadeep Date: 01/19/2012
Every Bug is a Microsoft bug until proven otherwise
Holiday season provides us an opportunity to take a break from our hectic schedules in GTSC and...
Author: Snehadeep Date: 01/19/2012
Package Configuration File Editor for SSIS available for download
A new tool for SSIS 2008 and 2008 R2 is now available for editing package configuration files. The...
Author: Snehadeep Date: 01/11/2012
Data migration of large Sybase tables may cause TEMPDB errors
Problem: During data migration of a large Sybase table using SSMA 5.x for Sybase ASE, the following...
Author: Snehadeep Date: 11/17/2011
‘Login Failed’ ERRORLOG message from SSMA 5.1 for Oracle’s sequence emulator
Problem: Sporadically, the SSMA 5.1 Oracle sequence emulator causes login failure (Error: 18456,...
Author: Snehadeep Date: 11/17/2011
Deploying SQL CLR assembly using Asymmetric key
In my opinion, One of the most complex part in deploying SQL CLR stored procedure is when you need...
Author: Snehadeep Date: 10/28/2011
Unable to do SQL Stored Procedure debugging remotely from VS2010
This post describes an interesting scenario that I came across when working with on Visual Studio...
Author: Snehadeep Date: 10/27/2011
How a DBA can confirm if Microsoft JDBC XA transactions are set
I am from Microsoft SQL Developer Support team, we support many data access technologies. Recently I...
Author: Snehadeep Date: 10/26/2011
ODBC drivers not visible in the ODBC Data Source Administrator (odbcad32.exe)
I recently had an issue where after the installation of a Third party Client side tools, we were not...
Author: Snehadeep Date: 10/18/2011
Troubleshooting “Cannot create an instance of OLE DB provider”
Today I am going to blog about a frequent issue that we come across while creating linked server-:...
Author: Snehadeep Date: 09/28/2011
How to verify if the issue is due to linked server or provider
When we create a linked server to a database Other than SQL server, like Sybase , Oracle , DB2 etc...
Author: Snehadeep Date: 08/19/2011
Calling SSIS Execute Process task from a remote batch file.
This post describes an interesting scenario that I came across when working with a SSIS package...
Author: Snehadeep Date: 08/05/2011
SSMA 5.0 for Access and the DAO requirement
My name is Angshuman Nayak and I am a part of SQL Developer support in Microsoft and work mostly...
Author: Snehadeep Date: 08/05/2011
Sync framework might fail to sync data
Database sync might not work if we copy the same database file to all the clients after provisioning...
Author: Snehadeep Date: 06/16/2011
ExecuteCommandTextErrorHandling error while using SSMA for Sybase
I had a Sybase to SQL server migration related issue recently. While working on it I discovered a...
Author: Snehadeep Date: 05/19/2011
Microsoft Releases SQL Server Migration Assistant (SSMA) v.5.0
Microsoft announced today the release of SQL Server Migration Assistant (SSMA) v5.0, a family of...
Author: Snehadeep Date: 04/29/2011
Unable to retrieve next sequence value from a migrated Oracle sequence
Background: SSMA 4.2 emulates an Oracle sequence as a table containing an IDENTITY column. Each...
Author: Snehadeep Date: 04/08/2011
SQLExceptions while trying to perform add , delete or update operation using the DataGridView control
You may see some SQLExceptions while trying to perform add , delete or update operation using the...
Author: Snehadeep Date: 02/23/2011
Executing an INSERT statement on a View in linked server
Consider this scenario where you have a linked server from one SQL server to another SQL Server....
Author: Snehadeep Date: 02/22/2011
The SSIS and Excel Story Continues
Folks, in my continued experimentation with SSIS and Excel I found out another roadblock which is...
Author: Snehadeep Date: 01/21/2011
Importing Excel 2010 Data into Sql Server
Guys, I was really excited to find out that Excel 2010 overcomes the limitation of having a maximum...
Author: Snehadeep Date: 01/21/2011
Basic troubleshooting for SSIS
This is a video blog about troubleshooting basic SSIS issues. It basically covers 4 topics –:...
Author: Snehadeep Date: 01/11/2011