June 2, 2010 at 12:39 am
Hii friends,
i m trying to bulkinsert one file but i m getting error
foll is the script
declare @filename varchar(20),@BulkCSVImport varchar(200)
set @filename = '20071106.txt'
set @BulkCSVImport = 'BULK INSERT VWAP.dbo.MsgTrackingLogs From ''C:\'+ @filename' with (FIRSTROW = 2)'
Exec (@BulkCSVImport)
Msg 102, Level 15, State 1, Line 4
Incorrect syntax near ' with (FIRSTROW = 2)'.
plz help
Sanket Ahir
Don't run behind the success, Try to be eligible & success will run behind u......
June 2, 2010 at 3:28 am
This was removed by the editor as SPAM
June 2, 2010 at 5:18 am
getting this error
Msg 105, Level 15, State 1, Line 1
Unclosed quotation mark after the character string 'C:\20071106.txt with (FIRSTROW = 2)'.
Msg 102, Level 15, State 1, Line 1
Incorrect syntax near 'C:\20071106.txt with (FIRSTROW = 2)'.
Sanket Ahir
Don't run behind the success, Try to be eligible & success will run behind u......
June 2, 2010 at 5:32 am
This was removed by the editor as SPAM
June 2, 2010 at 6:32 am
thanx
Sanket Ahir
Don't run behind the success, Try to be eligible & success will run behind u......
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply