May 16, 2002 at 8:19 am
Hi,
does anyone know if I can use BULK INSERT statment to load a file that resides on another domain ? How can this be done?
And what about if this files resides on another machine on the same domain ?
Can it be done ?
THank you
May 16, 2002 at 8:52 am
If you have access to the file you can do it.
Andy
May 16, 2002 at 3:06 pm
If this will be automated using SQLAgent on another domain may give issues with permissions of the account SQLAgent is using(sorry I haven't tried but a trust between the domains should help you around ask an NT Admin who has done this to help). If on the same domain then the account SQLAgent is running under has to have access to that machines and the file path itself.
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply