Import / Deployment / Execution of SSIS packages fails after you migrate SSISDB from SQL Server 2012 to SQL Server 2014.

  In this blog, I would like to discuss about one of the interesting scenarios that you would witness after you migrate your existing SSISDB catalog from SQL Server 2012 to SQL Server 2014. Issue: Whenever you try to deploy your new Integration services projects to the migrated SSISDB catalog (of SQL Server 2014) using…


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…

111

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…

20

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 with a SSIS package developer. The design of the package consist of one main parent package having several “Execute Package Task” that calls multiple child packages from the file system location. The actual issue here was…

5

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 Package Configuration File Editor identifies configuration paths that are not valid and enables you to correct the paths without having to open the package in Business Intelligence Development Studio (BIDs). Package configuration paths can become invalid when…

2