Hi all Im experiencing a strange error in a simple ssis package i have. The package contains a simple "Execute SQL Task" that has a connectiontype "EXCEL" and connection set up to a pre configured Excel connection manager. The task is supposed to simply create a new spreadsheet using CREATE TABLE sql statement within the task. It seems to run fine on a colleagues computer, however when im trying to run it on mine i experience the following error: "[Execute SQL Task] Error: Failed to acquire connection "Excel Connection Manager_LPL". Connection may not be configured correctly or you may not have the right permissions on this connection." Is this a permissions problem as it hints at? Would it be permissions on the directory being written to or elsewhere? Any advice appreciated. Thanks.

Possibly permissions on the folder where the Excel file is stored. What happens if you run the package from your colleague's machine logged in as you, or he/she runs it on YOUR machine, logged in as him/herself? That would give you an indication if permissions are keeping you locked out. Another thought: Is the file path based on a mapped drive? If so (unadvisable) make sure the drive mapping is the same. (Better: use \\server\share\folder format when referring to external files). Otherwise, it might be a driver issue. does your machine have the same drivers as the other? What Provider are you selecting? "Excel", or the Microsoft OLE DB provider for Office 12? If you don't have Office 2007 or later on your machine, that one will fail. But there is a download that will allow SSIS to connect to Excel via OLE DB. Let us know what works out. Todd C - MSCTS SQL Server 2005 - Please mark posts as answered where appropriate.

Thank you for the reply Todd. I have been checking the permissions and it doesn't seem to be down to these following the tests you suggested. The connection string is as follows: "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\Documents\Compare\;Extended Properties="Excel 12.0;HDR=YES";" I think possibly i need to install the driver you mentioned? Do you know where i can get this from? Thank you.

I have now resolved this problem. I was running the package on my computer with the Runas64Bit project property as TRUE. Changing this to false fixed the issue. I believe this is because the version of drivers I have for excel - ssis connectivity are 32bit.