use xp_cmdshell to run BulkExport

#1

hi,
I get errors while executing BulkExport via store procedure , xp_cmdshell.
Below are some error messages,
DTSRun OnError: BulkExport_P_Step, Error = 440 (1B8)
Error string: Automation error

I also execute the same package in DOS command, and it works.

I have BulkExport executed on main package thread.

Any ideas ?

TIA

#2

Steffi,

DOS uses you windows session account and xp_cmdshell uses SQL Server service
account. Make sure the service account has access to whatever is important
to BulkExport.

Ilya

"Steffi" <steffibev (AT) hotmail (DOT) com> wrote

Quote:

hi,
I get errors while executing BulkExport via store procedure ,
xp_cmdshell.
Below are some error messages,
DTSRun OnError: BulkExport_P_Step, Error = 440 (1B8)
Error string: Automation error

I also execute the same package in DOS command, and it works.

I have BulkExport executed on main package thread.

Any ideas ?

TIA

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

use xp_cmdshell to run BulkExport

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

use xp_cmdshell to run BulkExport - 09-13-2004 , 10:42 PM

Re: use xp_cmdshell to run BulkExport - 09-14-2004 , 08:49 AM