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 its huge ecosystem that has arisen around the core functionalities of Hadoop distributed file system (HDFS™) and Hadoop Map Reduce. As of today, being able to have SQL Server working with Hadoop™ becomes increasingly important because the two are…

1

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

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.Interop.Excel; using Excel = Microsoft.Office.Interop.Excel; using System.Runtime.InteropServices; Excel.Application m_ExcelApplication = new Excel.Application(); m_ExcelApplication.Visible = false; m_ExcelApplication.UserControl = false; m_ExcelApplication.Application.ScreenUpdating = false; m_ExcelApplication.DisplayAlerts…

84

Openrowset and FoxPro Database

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 completely to SQL Server and hence…

0

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 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 have seen many issue with connectivity to SQL but the solution we…

15

Why is my command not timing out (JDBC)?

  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 care of most single-query statements that we might want to issue. The situation becomes more complicated when dealing with statement…

1

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 to parameterized stored procedure fails parsing with error: Syntax error, permission violation, or other nonspecific error If we change the connection manager to use Microsoft OLE DB Provider for Sql Server, the same query with parameters…

1

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 "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 set up Sql 2012 Servers when I tried to deploy a project to the SSIS Catalog using the Project Deployment Model. I…

16

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 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 set is available in UTF-8 with the same code point values. One…

7

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 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 data to .mdf file which was on file system. In today’s blog…

4