file name in OPENDATASOURCE()

  • Hello,

    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-----

    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.

    Thank you!

Viewing 0 posts

You must be logged in to reply to this topic. Login to reply