Hi,

I am trying to import some text files from a Novell Share.

The problem is - if I run the dts package manually it
works fine, but if run it programatically (using extended
stored procs) it does not. SQLServer service is running
under a domain account which has got permissions on that
Novell share.

any ideas????? I am feeling stuck, there must be some
sort of magic button that I have to press, because it
works manually.

Looks like this is a big challenge for SQL
Gurus/DBAs!!!!!!!!!!!!!!!!

For my information:
http://www.sql-server-performance.com/forum/topic.asp?
TOPIC_ID=5165

Mr Gates,

Thanks for the reply.

1. I don't have .NET/IIS installed on my SQL Server, so
there are no accounts called IUser.. and IWAM...

2. Even if I do install these, IUser.. and IWam would be
local users on that machine and will not be able see
anything on the network.

what do you think?
jas...

Thanks OK.

One way of running DTS programatically is calling DTSRun
using xp_cmdshell extended stored proc. e.g.

EXEC master.dbo.xp_cmdshell 'dtsrun /S sldn057 /U sa /P
***** /N jasDTSUser'

If I run the above command in Query Analyser, it does not
work. SQL Server service is runnng under a domain account
that have access to Novell Share.

jas...