"RJ" <RJ@discussions.microsoft.com> wrote in message
news:0049FF51-B000-4694-BCA3-309FC5FB88C0@microsoft.com...
> Hi,
> I've been trying to get bulk insert to work and have this statement
>
> bulk insert dbo.myTable from 'c:\test.csv'
> with (datafiletype='char', FIELDTERMINATOR = ',',ROWTERMINATOR = '\n')
>
> I'm trying to get this to work in the SQL query analyzer. But i see that
> it
> is trying to find this file on the C:\ drive of the box where sqlserver is
> running. not on the box where the query analyzer is connecting to
> sqlserver
> from.
> As such, i was wondering if there is a way to call bulk insert with the
> file
> not residing on the same machine as the sql server. I tried doing it from
> the
> networked drive and from a \\dir shared directory.
> it did not work
> how do you call bulk insert and load from a remotely located file?
> thanks
>
>
>
>

"RJ" wrote:

> Hi,
> I've been trying to get bulk insert to work and have this statement
>
> bulk insert dbo.myTable from 'c:\test.csv'
> with (datafiletype='char', FIELDTERMINATOR = ',',ROWTERMINATOR = '\n')
>
> I'm trying to get this to work in the SQL query analyzer. But i see that it
> is trying to find this file on the C:\ drive of the box where sqlserver is
> running. not on the box where the query analyzer is connecting to sqlserver
> from.
> As such, i was wondering if there is a way to call bulk insert with the file
> not residing on the same machine as the sql server. I tried doing it from the
> networked drive and from a \\dir shared directory.
> it did not work
> how do you call bulk insert and load from a remotely located file?
> thanks
>
>
>