Guys i have trigger sitting on a table for insert. when the trigger is fired
it will execute a dts package using dts run. The dts package pumps data from
the sql server to a access table and run three simple querries on it.

The table get it's insert from a sql server se database. and the trigger
fires the dts but it only execute the data pump. it doesnt execute the three
querries i have there.

but if i use the querry analyzer to insert a value to the table the DTS run
perfectly... can some one please help me here. kind regards

Turn on the pacakge error log file and the log to SQL server option to try
and get soem more information and what is happening. We really need an error
rmessage to try and help.

I actually think what you are doing is a really bad idea, calling external
componenst insie a SQL server transaction.

How can I execute a DTS package from a trigger
(http://www.sqldts.com/default.aspx?219)


--
Darren Green
http://www.sqldts.com

"Las" <Las (AT) discussions (DOT) microsoft.com> wrote

DTSRun: Loading...
DTSRun: Executing...
DTSRun OnStart: DTSStep_DTSExecutePackageTask_1
DTSRun OnProgress: DTSStep_DTSExecutePackageTask_1; Copy Data from tblStock
to tblStock Step: 1 Rows have been transformed or copied.; PercentComplete =
0; ProgressCount = 1
DTSRun OnFinish: DTSStep_DTSExecutePackageTask_1
DTSRun OnStart: DTSStep_DTSExecuteSQLTask_1
DTSRun OnError: DTSStep_DTSExecuteSQLTask_1, Error = -2147467259 (80004005)
Error string: 'W:\fbase' is not a valid path. Make sure that the path
name is spelled correctly and that you are connected to the server on which
the file resides.
Error source: Microsoft JET Database Engine
Help file:
Help context: 5003044

Error Detail Records:

Error: -2147467259 (80004005); Provider Error: -534774783 (E01FFC01)
Error string: 'W:\fbase' is not a valid path. Make sure that the path
name is spelled correctly and that you are connected to the server on which
the file resides.
Error source: Microsoft JET Database Engine
Help file:
Help context: 5003044

DTSRun OnFinish: DTSStep_DTSExecuteSQLTask_1
DTSRun OnStart: DTSStep_DTSExecuteSQLTask_2
DTSRun OnError: DTSStep_DTSExecuteSQLTask_2, Error = -2147467259 (80004005)
Error string: 'W:\fbase' is not a valid path. Make sure that the path
name is spelled correctly and that you are connected to the server on which
the file resides.
Error source: Microsoft JET Database Engine
Help file:
Help context: 5003044

Error Detail Records:

Error: -2147467259 (80004005); Provider Error: -534774783 (E01FFC01)
Error string: 'W:\fbase' is not a valid path. Make sure that the path
name is spelled correctly and that you are connected to the server on which
the file resides.
Error source: Microsoft JET Database Engine
Help file:
Help context: 5003044

DTSRun OnFinish: DTSStep_DTSExecuteSQLTask_2
DTSRun OnStart: DTSStep_DTSExecuteSQLTask_14
DTSRun OnError: DTSStep_DTSExecuteSQLTask_14, Error = -2147467259 (80004005)
Error string: 'W:\fbase' is not a valid path. Make sure that the path
name is spelled correctly and that you are connected to the server on which
the file resides.
Error source: Microsoft JET Database Engine
Help file:
Help context: 5003044

Error Detail Records:

Error: -2147467259 (80004005); Provider Error: -534774783 (E01FFC01)
Error string: 'W:\fbase' is not a valid path. Make sure that the path
name is spelled correctly and that you are connected to the server on which
the file resides.
Error source: Microsoft JET Database Engine
Help file:
Help context: 5003044

DTSRun OnFinish: DTSStep_DTSExecuteSQLTask_14
DTSRun: Package execution complete.
NULL

Have you solved it now you know the error?

Looks like the path is wrong for the SQL Server machine to be accessing,
or perhaps the security context has no permissions to this file.

Darren

In message <69B92109-AF07-4A70-9413-D8B21E24FC12 (AT) microsoft (DOT) com>, Las
<Las (AT) discussions (DOT) microsoft.com> writes
--
Darren Green (SQL Server MVP)
DTS - http://www.sqldts.com

PASS - the definitive, global community for SQL Server professionals
http://www.sqlpass.org