I may be asking silly question!
I am using SQL Server 2005 Standard Edition (SP2).
I ran query using OPENDATASOURCE(). I am using tab delimited text file as "Data Source". I got following SQL exception when I ran query with "ParthaMishra_1172_Sov_ITMSUpload_UnitedWay_NewEngland_2009Final.txt" file name.
Exception in Thread com.microsoft.sqlserver.jdbc.SQLServerException: The OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "(null)" does not contain the table "ParthaMishra_1172_Sov_ITMSUpload_UnitedWay_NewEngland_2009Final#txt". The table either does not exist or the current user does not have permissions on that table.
Interestingly, I ran the query again after changing name of the file to "PPM_ITMSUpload_1172.txt" and it worked.
So my question is: Is there anything with length of file name when using OPENDATASOURCE()?
The physical paths of the file are "E:\PMS\UploadedFiles\23055\2008\emp_CBD6042EEB20D1B68E1A51F194B024BD_1221156673057\ParthaMishra_1172_Sov_ITMSUpload_UnitedWay_NewEngland_2009Final.txt" and "E:\PMS\UploadedFiles\23055\2008\emp_CBD6042EEB20D1B68E1A51F194B024BD_1221157087084\PPM_ITMSUpload_1172.txt"
Please clarify me.