<div>
The usual problem I have run into with this is that the drive where the txt file resides may not be mapped the same way at the Server where SQL resides as on my dev box. &nbsp;Have you tried using the UNC name of the drive rather than a mapped drive letter?<br />
<br />
-- Steve
</div>


The usual problem I have run into with this is that the drive where the txt file resides may not be mapped the same way at the Server where SQL resides as on my dev box.  Have you tried using the UNC name of the drive rather than a mapped drive letter?

-- Steve

<div>
please delete this question
</div>


<div>
i dnt want you to take any points from the members.. just close this question
</div>


i dnt want you to take any points from the members.. just close this question

<div>
<div class="content wysiwyg-content">
The directory and file is there nothing wrong with the network drive<br />
Can anyone tell me how to resolve this error?<br />
<br />
Could not bulk insert because file ' K:\Apps\orderlog\APAPORD1.<wbr />txt ' could not be opened. Operating system error code 123(The filename, directory name, or volume label syntax is incorrect.).
</div>
</div>


The directory and file is there nothing wrong with the network drive
Can anyone tell me how to resolve this error?

Could not bulk insert because file ' K:\Apps\orderlog\APAPORD1.txt ' could not be opened. Operating system error code 123(The filename, directory name, or volume label syntax is incorrect.).

bulk insert error

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.