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 |
|
pelegk2
Aged Yak Warrior
723 Posts |
 Posted - 2008-06-22 : 03:21:00
|
i have tried to move upload of files from SQL2000 to SQl2005.in SQL2005 i have created a JOB in which has 2 steps,each one of them activates the same batch files i used in SQL2000 (where i have change the server name and so on),for example : for %%f in ( %BULK_UPLOAD_BASE%\Temp%1\*.txt) do bcp "db1.dbo.Test_TargetTable" in %%f -S SERVER-REP -U n145 -h "TABLOCK" -e %BULK_UPLOAD_BASE%\Error\Err10.txt -o %BULK_UPLOAD_BASE%\Logs\Output10.txt -P n145 -C RAW -f %BULK_UPLOAD_BASE%\format_with_RawData_4test.fmt when irun this code in a bat file, the data is loaded with no problem.when i run the JOB i see in the LOG that everything was ok, but actually the data fromthe files was not loaded - any idea why?thnaks in advancepelegIsrael -the best place to live in aftr heaven 9but no one wan't to go there so fast -:) |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-06-22 : 17:11:39
|
| Where is data file? Does sql agent account have permission to access it? |
 |
|
|
|
|
|
bulk upload files