The Jet driver has no FileStream direct access methods. Furthermore, the Excel source neither. You do need to extract the file 1st to operate on it. Reason: the files in the FileStream table are in binary format until exacted.Arthur My Blog

Thanks for the explanation, although I wish there were better news. Is there any alternative to the Jet driver that you are aware of that would allow programmatic access to the data withought copying out the stream to a temporary location? (I realize that Excel automation could be used but it is far, far too slow and in any event I don't want to install Excel on the server)

No driver was provisioned to operate directly over the FileStream. The intent is to operate on it from within T-SQL.Arthur My Blog

Can you point me to a T-SQL example that illustrates how to extract the Excel data from the stream? Perhaps some variety of openrowset?

This blog post is good IMO: it shows the T-SQL and the .Net code you can use inside a Script Task, right in your package: http://blogs.msdn.com/b/spike/archive/2011/02/28/inserting-a-file-into-a-filestream-table-from-c-and-how-to-get-it-back-as-well.aspxArthur My Blog

I am attempting to create an excel data source for a file that is located on a Sql Server Filetable network share. When setting up the source, I receive a very nondescript error. If the file is placed on a system drive, there is no issue and the Excel application itself has no issue opening the file from the Filetable share. Attempting to diagnose the problem, I created a console app that attempts to load the workboook via the Jet driver. The error information is: The Microsoft Jet database engine cannot open the file ''. It is already opened exclusively by another user, or you need permission to view its data. Again, there is no issue here if the file is on a fixed drive. I have also tried mapping a drive to the share and get the same error. The only workaround I've found is to copy the file to a temp directory on a fixed drive, but this really isn't an acceptable solution. Any ideas about what's causing this and how to resolve it?