Browse by Tags

Blog Post: Getting Cross Domain Kerberos and Delegation working with SSIS Package

SQL Server Support Content

I started working on this issue started by way of a Twitter conversation between myself, Jorge Segarra ( @sqlchicken ) and Matt Masson ( @mattmasson ). I then found out that Jorge was working with a customer that had opened up a Support Case. Also ...read more

on 26 Jun 2014
Blog Post: Calling SSIS Execute Process task from a remote batch file.

SQL Server Support Content

This post describes an interesting scenario that I came across when working with a SSIS package developer. The main issue was that we were unable to run the SSIS package that contains a execute process task calling a batch file stored on a remote server ...read more

on 5 Aug 2011
Blog Post: Error ‘Microsoft Office Excel cannot access the file’ while accessing Microsoft Office 11.0 Object Library from SSIS

SQL Server Support Content

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

on 19 Dec 2012
Blog Post: Package Configuration File Editor for SSIS available for download

SQL Server Support Content

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

on 11 Jan 2012
Blog Post: Leveraging a Hadoop cluster from SQL Server Integration Services (SSIS)

SQL Server Support Content

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

on 19 Dec 2012
Blog Post: Could not load package because of error 0x80070002 while upgrading from SSIS 2008 to SSIS 2012

SQL Server Support Content

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

on 28 Sep 2012
Blog Post: 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.

SQL Server Support Content

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

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

SQL Server Support Content

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

on 20 Aug 2012
Blog Post: Syntax error, permission violation, or other nonspecific error

SQL Server Support Content

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

on 20 Aug 2012

Products

Resources

Solutions

Updates

Trials

Related Sites

Training

Certifications

Other resources

Support options

More support

Not an IT pro?

SQL Server KBs and Blogs

Browse by Tags

Blog Post: Getting Cross Domain Kerberos and Delegation working with SSIS Package

Blog Post: Calling SSIS Execute Process task from a remote batch file.

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

Blog Post: Package Configuration File Editor for SSIS available for download

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

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

Blog Post: 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.

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

Blog Post: Syntax error, permission violation, or other nonspecific error