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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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