|
On 6/1/2013 8:56 PM, Peter Connell wrote:
I want to load a file in a database on SQL Server 2008 R2 using SQL bulk insert from a csv file.
So that I can use the IFS on the i5 I would like to mount the SQL server using the MOUNT command but need some advice as this is new to me.
The MOUNT cmd has the format MOUNT TYPE(*NFS) MFS(?????)
MNTOVRDIR(??????) and I need to know what to specify for MFS and
MNTOVRDIR
The host name of the SQL Server box is nzaklgl-db601.corp.bayadv which
can be pinged from the i5 and returns an IP address of 10.9.64.65 If I
log on to the SQL Server machine and look at the drives via Windows
Explorer I see the following
Computer
OS(C:)
Data(F:)
Logs(H:)
Work(I:)
Backup(K:)
...
...
I figure that I need a folder in one of these drives to be the target of the MOUNT.
So what do I specify for MFS and MNTOVRDIR?
Peter
######################################################################
###############
This correspondence is for the named person's use only. It may contain
confidential or legally privileged information, or both. No
confidentiality or privilege is waived or lost by any mistransmission.
If you receive this correspondence in error, please immediately delete
it from your system and notify the sender. You must not disclose, copy or rely on any part of this correspondence if you are not the intended recipient.
Any views expressed in this message are those of the individual
sender, except where the sender expressly, and with authority, states them to be the views of Veda.
If you need assistance, please contact Veda on either :- Australia
1300-762-207 or New Zealand +64 9 367 6200
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.