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 |
|
whitmoj
Yak Posting Veteran
68 Posts |
 Posted - 2009-01-27 : 04:33:22
|
Good MorningI am currently trying to do a Bulk Insert with the following codeBULK INSERT s4les.BecogentDataFROM '\\kn-bifisql\Becogent:\VM_CMC.txt'WITH (FIELDTERMINATOR = '|',ROWTERMINATOR = ',\n')I Know this works as I have used it in the past the error I am getting is that it can not open '\\kn-bifisql\Becogent:\VM_CMC.txt'. The only difference is that my drive were the txt file is has a user name and password. Any ideas would help. Many Thanks WhitmojIf I have inspired one person today then my job is done. |
|
|
AvanthaSiriwardana
Yak Posting Veteran
78 Posts |
Posted - 2009-01-27 : 04:58:54
|
| so then check with the drive permissionAvantha Siriwardana |
 |
|
|
whitmoj
Yak Posting Veteran
68 Posts |
Posted - 2009-01-27 : 05:06:39
|
| I have done this and all is fine on this frontWhitmojIf I have inspired one person today then my job is done. |
|
|
|
heavymind
Posting Yak Master
115 Posts |
Posted - 2009-01-27 : 08:03:07
|
| I wonder if ":" can be used within UNC path...Thanks, VadymMCITP DBA 2005/2008Chief DBA at http://www.db-staff.com |
|
|
|
|
|
|
Bulk Insert