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.
| Author |
Topic |
|
TAS
Yak Posting Veteran
65 Posts |
 Posted - 2004-04-12 : 10:23:22
|
| I try to bulk copy a text file into a table, I want to start to copy from the 2nd row of file. I have the code below:bulk insert Test from "I:\Windows\A020204.txt" With (FirstRow=2)But I get result: (0 row(s) affected)Why it doesn't copy? |
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2004-04-12 : 11:08:59
|
| Is the file empty?Can you open it with wordpad?Is the file fixed width or delimited?What's the table DDL?Brett8-) |
 |
|
|
graz
Chief SQLTeam Crack Dealer
4149 Posts |
Posted - 2004-04-12 : 11:18:21
|
| Can SQL Serve see the I: drive? You might try a UNC name.===============================================Creating tomorrow's legacy systems today.One crisis at a time. |
|
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2004-04-12 : 11:36:19
|
quote:
Originally posted by graz
Can SQL Serve see the I: drive? You might try a UNC name.===============================================Creating tomorrow's legacy systems today.One crisis at a time.
If it was a mapping issue, they'd get an error...no?Brett8-) |
|
|
|
|
|
|
bcp problem