BULK INSERT Syntax SQL?

To specify a shared data file, use its universal naming convention (UNC) name, which takes the general form, \Servername\Sharename\Path\Filename. Additionally, the account used to access the data file must have the permissions that are required for reading the file on the remote disk.

To specify a shared data file, use its universal naming convention (UNC) name, which takes the general form, \Servername\Sharename\Path\Filename. Additionally, the account used to access the data file must have the permissions that are required for reading the file on the remote disk. BULK INSERT AdventureWorks2008R2.Sales.

SalesOrderDetail FROM '\\computer2\salesforce\dailyorders\neworders. Txt'; GO msdn.microsoft.com/en-us/library/ms17591....

Its the issue of referencing an internet file that I am having issues with...remotely uploading a file from the internet – CraigJSte Dec 11 '10 at 13:32.

Its two slashes and no http BULK INSERT dbo. FNSR FROM '\\yahoodd.velocitytrading. Net\txtfiles\FNSR.

Txt' WITH ( FIRSTROW = '2', FIELDTERMINATOR = '\t', ROWTERMINATOR = '\n' ).

It was due to the virtual path not being found I think... I am going to use an IP address but this does over come the initial error – CraigJSte Dec 11 '10 at 12:36 I totally give up.. I have tried referencing IP address, moving it to parent domain, checking security profiles for having Bulk Insert Rights and it just will not see the file, I don't think this is possible, I am moving on to Bulk Copy using C# and DataTables – CraigJSte Dec 11 '10 at 13:31.

It has to be a local drive. The "FROM 'http:\yahoodd.velocitytrading. Net\txtfiles\FNSR.

Txt'" should be replaced by "C:.......\some. Txt" if it is from ... You will have to stream through it.

I cant really gove you an answer,but what I can give you is a way to a solution, that is you have to find the anglde that you relate to or peaks your interest. A good paper is one that people get drawn into because it reaches them ln some way.As for me WW11 to me, I think of the holocaust and the effect it had on the survivors, their families and those who stood by and did nothing until it was too late.