Do not use on any
shared computer
August 20, 2008 03:45am pdt
 
[x]
Attachment Details

INSERT ON SQL 2005

Tags: insert, 2005, sql
I was using the below script on SQL 2005 to bulk insert in query analyser :
The problem is that it's not processing the file but the file has got full admin right and the server where am running the script from has got access to the file. but still getting o row affected please help any ideal

BULK INSERT [dbo].[tb_ImportedValueTempImport]
                  FROM '\\ukdc01-ldb-003\OBS$\Rex Import Testing 5 - Rex Testing Imported Value Drilldown - Gold Option - 2007-12-01 to 2007-12-31.txt'
                  WITH (
                           FIELDTERMINATOR = '|'
                           ,ROWTERMINATOR = '\n'
                        )
Start your free trial to view this solution
Question Stats
Zone: Microsoft
Question Asked By: Richardsoet
Question Asked On: 12.06.2007
Participating Experts: 2
Points: 125
Views: 0
Translate:
Loading Advertisement...
 
[+][-]Expert Comment by imitchie

Rank: Wizard

Expert Comment by imitchie:

All comments and solutions are available to Premium Service Members only.

Start your 7-day free trial and see for yourself why Experts Exchange is the easiest and most proven technology resource in the world. Get Started

Already a member? Login to view this solution.

 
 
[+][-]Expert Comment by gbshahaq

Rank: Wizard

Expert Comment by gbshahaq:

All comments and solutions are available to Premium Service Members only.

Start your 7-day free trial and see for yourself why Experts Exchange is the easiest and most proven technology resource in the world. Get Started

Already a member? Login to view this solution.

 
 
Loading Advertisement...
20080723-EE-VQP-34 / EE_QW_2_20070628