Data Access Technologies

Flat File source cannot handle file with uneven number of columns in each row

Snehadeep — Wed, 13 Mar 2013 18:17:07 GMT

I hope not many people are using flat file with such kind of structure, but if you are then no worries now you don’t have to do any weird adjustments. J I took some time to figure out what is going wrong here and why it is not working, and it caused some...(read more)

Lookup Transform Error: Row yielded no match during lookup

Snehadeep — Wed, 13 Mar 2013 18:11:13 GMT

Guys, Recently, I had to implement a lot of data warehousing solutions, hence I stumbled on an error in the SSIS Lookup transform task which I wanted to share. Most of my package tasks went on fine till it hit the below error in the Lookup task after...(read more)

"Cursor operation conflict" error while inserting data from flat file source to OLEDB destination

Snehadeep — Tue, 05 Mar 2013 15:23:47 GMT

I was working on one of the issue related with SSIS OLEDB destination editor. Here is the scenario. We are fetching the record from the excel file and inserting into the SQL through SSIS by using flat file source and OLEDB destination. While running the...(read more)

Integration services packages using Execute process task with WinZip32.exe fails intermittently, when run under a SQL Server Agent Job:

Snehadeep — Mon, 04 Mar 2013 16:22:09 GMT

This blog is about one of the known issues that anyone would run into when executing an Integration services package that contains an Execute Process Task calling a custom or 3 rd party executable scheduled through a SQL Agent job. The scheduled job fails...(read more)

Why is my Stored Procedure executed twice?

Snehadeep — Mon, 04 Mar 2013 16:17:43 GMT

Yesterday morning I spent quite a few hours on a problem that almost made my crazy. It was a simple little SSIS package executing a stored procedure on my SQL and writing the data out to a disk file. I used an OLE DB Source in my Data Flow and the first...(read more)

Leveraging a Hadoop cluster from SQL Server Integration Services (SSIS)

Snehadeep — Wed, 19 Dec 2012 18:18:41 GMT

With the explosion of data, the open source Apache™ Hadoop™ Framework is gaining traction thanks to its huge ecosystem that has arisen around the core functionalities of Hadoop distributed file system (HDFS™) and Hadoop Map Reduce. As of today, being...(read more)

Error ‘Microsoft Office Excel cannot access the file’ while accessing Microsoft Office 11.0 Object Library from SSIS

Snehadeep — Wed, 19 Dec 2012 15:38:50 GMT

Folks, yet another stumble with SSIS and Excel. This time I am using Microsoft Office 11.0 Object Library. The code runs fine on Windows Server 2003. Below is the code sample. ======================================================= using Microsoft.Office...(read more)

Openrowset and FoxPro Database

Snehadeep — Wed, 19 Dec 2012 15:28:17 GMT

I wanted to write about one of my experiences where I nearly pulled off my hair while trying to make an Openrowset call to my FoxPro Database work from my SQL Server. It was high time when we decided to move over, discard my old FoxPro databases and migrate...(read more)

Error Message "Login failed. The login is from an untrusted domain and cannot be used with Windows authentication."

Snehadeep — Wed, 19 Dec 2012 15:25:00 GMT

My name is Archana CM from Microsoft SQL Developer Support team, we support SQL Connectivity issue along with data access technologies and SSIS. I had chance to work with SQL DBA who was having issues while connecting to his SQL server machine. We...(read more)

Could not load package because of error 0x80070002 while upgrading from SSIS 2008 to SSIS 2012

Snehadeep — Fri, 28 Sep 2012 15:46:26 GMT

When doing an In-place upgrade from Microsoft SQL Server 2008 or 2008 R2 to SQL Server 2012, be aware of this little caveat with SSIS. Last week I upgraded (note, I did an in-place upgrade and not a side-by-side installation) my Sql 2008 instance to Sql...(read more)

Why is my command not timing out (JDBC)?

Snehadeep — Thu, 06 Sep 2012 18:14:28 GMT

When working with the Microsoft JDBC driver for SQL Server, handling query timeouts is usually a fairly straight-forward issue. The driver supports the java.sql.Statement.setQueryTimeout() method and setting a timeout value through code will take...(read more)

Syntax error, permission violation, or other nonspecific error

Snehadeep — Mon, 20 Aug 2012 15:31:00 GMT

While developing a package in BIDS 2008 if we use SNAC 10.0 driver in OLE DB Source connection, call to parameterized stored procedure fails parsing with error: Syntax error, permission violation, or other nonspecific error If we change the connection...(read more)

Error While Deploying SSIS 2012 project from SSDT to SSIS Catalog : System.ComponentModel.Win32Exception: A required privilege is not held by the client

Snehadeep — Mon, 20 Aug 2012 15:22:00 GMT

A .NET Framework error occurred during execution of user-defined routine or aggregate "deploy_project_internal": System.ComponentModel.Win32Exception: A required privilege is not held by the client. I ran across this issue in one of my newly...(read more)

Migrating UTF8 data from Oracle to SQL Server using SSMA for Oracle

Snehadeep — Thu, 09 Aug 2012 13:11:37 GMT

Before we could begin our Data Migration, you’ll need to clearly understand what is UTF8 is the 8-bit encoding of Unicode? It is a variable-width encoding and a strict superset of ASCII. This means that each and every character in the ASCII character...(read more)

Error: "The underlying provider failed on Open" in Entity Framework application

Snehadeep — Thu, 09 Aug 2012 13:06:54 GMT

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...(read more)

Error while creating Linked server "Cannot obtain the schema rowset "DBSCHEMA_TABLES_INFO" for OLE DB provider "SQLNCLI10" for linked server ‘LinkedServerName’"

Snehadeep — Thu, 09 Aug 2012 12:58:01 GMT

When we create linked server for SQL server 2000 on SQL server 2005/SQL server 2008 /SQL server 2008 R2 sometimes we see errors w.r.t schema. In this blog, I will discuss on why we get this type of error and also the solution to fix the error message...(read more)

Optimized Bulk Loading of Data into Oracle

Snehadeep — Wed, 11 Apr 2012 20:29:22 GMT

SQL Server 2008 and SQL Server 2008 R2 (Enterprise editions) support bulk loading Oracle data using Integration Services packages with the Microsoft Connector for Oracle by Attunity. For SQL Server 2005 and the non-Enterprise editions of SQL Server 2008...(read more)

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.

Snehadeep — Thu, 19 Jan 2012 19:47:00 GMT

This is my second blog and it is about a very interesting scenario that I came across when working with a SSIS package developer. The design of the package consist of one main parent package having several "Execute Package Task" that calls multiple...(read more)

Every Bug is a Microsoft bug until proven otherwise

Snehadeep — Thu, 19 Jan 2012 19:35:00 GMT

Holiday season provides us an opportunity to take a break from our hectic schedules in GTSC and ponder over some interesting cases in past few months. I had been a strong believer in the fact that a lot of bugs attributed to Microsoft are not Microsoft’s...(read more)

Package Configuration File Editor for SSIS available for download

Snehadeep — Wed, 11 Jan 2012 14:05:00 GMT

A new tool for SSIS 2008 and 2008 R2 is now available for editing package configuration files. The Package Configuration File Editor identifies configuration paths that are not valid and enables you to correct the paths without having to open the package...(read more)

Data migration of large Sybase tables may cause TEMPDB errors

Snehadeep — Thu, 17 Nov 2011 19:33:00 GMT

Problem: During data migration of a large Sybase table using SSMA 5.x for Sybase ASE, the following error may occur: "Can't allocate space for object 'temp worktable' in database 'tempdb' because 'system' segment is full/has no free extents. ...(read more)

‘Login Failed’ ERRORLOG message from SSMA 5.1 for Oracle’s sequence emulator

Snehadeep — Thu, 17 Nov 2011 19:29:00 GMT

Problem: Sporadically, the SSMA 5.1 Oracle sequence emulator causes login failure (Error: 18456, Severity: 14, State: 8) error messages to be written to the SQL Server ERRORLOG when used from an application using SQL authentication. Steps to...(read more)

Deploying SQL CLR assembly using Asymmetric key

Snehadeep — Fri, 28 Oct 2011 18:30:00 GMT

In my opinion, One of the most complex part in deploying SQL CLR stored procedure is when you need to enable it for “External_Access” or “Unsafe”. The third option is “Safe” , this is pretty straight forward and I am...(read more)

Unable to do SQL Stored Procedure debugging remotely from VS2010

Snehadeep — Thu, 27 Oct 2011 11:15:00 GMT

This post describes an interesting scenario that I came across when working with on Visual Studio Project based issue. In this situation, customer was unable to debug stored procedures on a remote SQL Server using Visual Studio. The SQL Server was...(read more)

How a DBA can confirm if Microsoft JDBC XA transactions are set

Snehadeep — Wed, 26 Oct 2011 23:22:00 GMT

I am from Microsoft SQL Developer Support team, we support many data access technologies. Recently I had a chance to work with SQL DBA, who was facing issue to confirm to his developers whether XA transactions were configured correctly or not. After...(read more)