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)
 Error while trying to Bilk insert for remote file

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2005-10-07 : 07:11:02
chandru writes "How to pass User Id & password in bulk insert.

error shown is :
Could not bulk insert because file '\\Shreekants\C$\PerfLogs\ProcessorTime_20051007.csv' could not be opened. Operating system error code 1326(Logon failure: unknown user name or bad password.).

the machine (shreekants) is my near by mcahine, which is available in my intranet."

SreenivasBora
Posting Yak Master

164 Posts

Posted - 2005-10-07 : 14:36:38
Chandru,

Can you check does your user has assigned "sysadmin and bulkadmin of fixed server roles" ?



With Regards
BSR
Go to Top of Page
   

- Advertisement -