|
Looper
Yak Posting Veteran
68 Posts |
 Posted - 04/29/2008 : 10:10:21
|
I have an application (.Net 2.0) that bulk imports a comma separated file into sql 2000. The app is currently on the database server, but what I want to know is can I install the app on another server i.e. my web server and the bulk import will still work, as I have been told it needs to be on the database server?
bulk import code i am currently using:
'BULK INSERT t_TImport_Untyped FROM ''' + @FileLocation + ''' WITH (CODEPAGE = ''Raw'',FIELDTERMINATOR = '','', ROWTERMINATOR = '',\n'')' |
Edited by - Looper on 04/30/2008 11:18:15
|
|
Bulk Import across servers
