SQL Server Performance Forum – Threads Archive

Import from excel problem

I have an excel file that I want to be able to load into my SQL Server table by the click of a button in my ASP.NET project. I have created a DTS package using the import/export wizard and also a stored procedure to execute the DTS package. This works fine if the excel file is on my desktop but when I try to use a file on a shared network drive it fails and I get the following error : DTSRun: Loading… DTSRun: Executing… DTSRun OnStart: Create Table [GE].[dbo].[DTSTest2] Step DTSRun OnFinish: Create Table [GE].[dbo].[DTSTest2] Step DTSRun OnStart: Copy Data from Results to [GE].[dbo].[DTSTest2] Step DTSRun OnError: Copy Data from Results to [GE].[dbo].[DTSTest2] Step, Error = -2147467259 (80004005) Error string: The Microsoft Jet database engine cannot open the file ‘H:Book1.xls’. It is already opened exclusively by another user, or you need permission to view its data. Error source: Microsoft JET Database Engine Help file: Help context: 5003051 Error Detail Records: Error: -2147467259 (80004005); Provider Error: -534709256 (E020FBF<img src=’/community/emoticons/emotion-11.gif’ alt=’8)’ /> Error string: The Microsoft Jet database engine cannot open the file ‘H:Book1.xls’. It is already opened exclusively by another user, or you need permission to view its data. Error source: Microsoft JET Database Engine Help file: Help context: 5003051 DTSRun OnFinish: Copy Data from Results to [GE].[dbo].[DTSTest2] Step DTSRun: Package execution complete. NULL Also ideally I want the user to be able to specify the path to the excel file. Is this possible somehow?

"Also ideally I want the user to be able to specify the path to the excel file. Is this possible somehow?" You can use the Dynamic Properties Task to change DTS task settings at run time. Raulie
Hewlett-Packard

]]>