Hi everyone,

I have written a sp which calls a dts package which I have tested and
works. I would like to schedule this sp so have put it in a dts
package to call a second package.

If the second package executes sql it works fine but if the second
package is used to import data from a text file it fails.

I can also call the sp from query analyser which runs the second
package to import the data and the sp also works if called through an
asp page.

I'm guessing that it is probably a security thing, although the sp
specifies server, username, password, dts package: which I have
specified the same while attempting to run the sp through each of
these methods

Any ideas


thanks

You are right it is probably a security thing. It more than likely has to
do with the text file

If you pass in the U and P parameters to the package then it will log on as
that. If that is a SQL Server sysadmin then the package will execute as the
SQL Server service account. What is this account? Does it have perms to
the text file ?

The U and P is only to log you on to SQL Server
--

----------------------------
Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org



"Arthur" <Arthur.Nyunt (AT) kellogg (DOT) com> wrote