Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Import/Export (DTS) and Replication (2000)
 Bulk Insert

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2006-02-16 : 07:52:02
manto writes "Im using bulk insert to copy a very large text file to a table in sql server. The input file had spaces as column delimiter
BULK INSERT dts FROM 'D:\data1.txt'
WITH (FIELDTERMINATOR = ' ' , FIRST ROW =
1,ROWTERMINATOR = '\n')

Though im not getting any errors while executing this query from a stored procedure the destination table seems to have no data. insert is not working."
   

- Advertisement -