Execute DTS package from .adp ?

Hello,

Currently I save a DTS as a storage file. I then run the storage file
with VBA code in the .adp(Access Data Project). This works if you run
the ADP on the Server but the users of the .adp will be opening it on
the network from their machines. When they do it says missing
custtask.dll and some other .dll these .dll are in the SQL server Binn
on the server so they are not on the users machines.
I could not register the .dlls on the user machines without SQL Server.

It would be great if I could solve this problem but I'm not sure
how....

Another possiblity would be to save the DTS SQL Server msdb table and
run it from the server but I do not know how to run the DTS using VBA
code or a SQL statement...

Please help with any documentation or suggestions,

ChuckHi

This may be useful:
http://www.sqldts.com/default.aspx?225

You could run the DTS package as a scheduled job
http://support.microsoft.com/?kbid=269074
or a job started manually
http://msdn.microsoft.com/library/d..._sa-sz_11uq.asp

John

<meyvn77@.yahoo.com> wrote in message
news:1126375425.946180.124620@.f14g2000cwb.googlegr oups.com...
> Hello,
> Currently I save a DTS as a storage file. I then run the storage file
> with VBA code in the .adp(Access Data Project). This works if you run
> the ADP on the Server but the users of the .adp will be opening it on
> the network from their machines. When they do it says missing
> custtask.dll and some other .dll these .dll are in the SQL server Binn
> on the server so they are not on the users machines.
> I could not register the .dlls on the user machines without SQL Server.
> It would be great if I could solve this problem but I'm not sure
> how....
> Another possiblity would be to save the DTS SQL Server msdb table and
> run it from the server but I do not know how to run the DTS using VBA
> code or a SQL statement...
> Please help with any documentation or suggestions,
> Chuck|||I really need to execute it using code or a SQL statement.|||So you will need to install/register all the dlls mentioned in the first
post on every client or possibly from your own stored procedure:

http://www.sqldts.com/default.aspx?210

John

<meyvn77@.yahoo.com> wrote in message
news:1126393799.257226.56930@.o13g2000cwo.googlegro ups.com...
>I really need to execute it using code or a SQL statement.

Execute DTS package from .adp ?

Hello,
Currently I save a DTS as a storage file. I then run the storage file
with VBA code in the .adp(Access Data Project). This works if you run
the ADP on the Server but the users of the .adp will be opening it on
the network from their machines. When they do it says missing
custtask.dll and some other .dll these .dll are in the SQL server Binn
on the server so they are not on the users machines.
I could not register the .dlls on the user machines without SQL Server.
It would be great if I could solve this problem but I'm not sure
how....
Another possiblity would be to save the DTS SQL Server msdb table and
run it from the server but I do not know how to run the DTS using VBA
code or a SQL statement...
Please help with any documentation or suggestions,
ChuckYou can dts runtime. You'd want to read the readme for details as to what's
distributable.
Meanwhile, you want to save your dts package on sqlserver (i.e. in msdb) and
then create a sqljob for the package. Then in your vba, you would invoke
sp_start_job 'jobname' to execute it.
-oj
<meyvn77@.yahoo.com> wrote in message
news:1126375373.241589.256440@.z14g2000cwz.googlegroups.com...
> Hello,
> Currently I save a DTS as a storage file. I then run the storage file
> with VBA code in the .adp(Access Data Project). This works if you run
> the ADP on the Server but the users of the .adp will be opening it on
> the network from their machines. When they do it says missing
> custtask.dll and some other .dll these .dll are in the SQL server Binn
> on the server so they are not on the users machines.
> I could not register the .dlls on the user machines without SQL Server.
> It would be great if I could solve this problem but I'm not sure
> how....
> Another possiblity would be to save the DTS SQL Server msdb table and
> run it from the server but I do not know how to run the DTS using VBA
> code or a SQL statement...
> Please help with any documentation or suggestions,
> Chuck
>

execute dts 2000 failure

I have used to the execute dts 2000 task in Visual Studio to successfully execute a structured storage file for a simple DTS package.

I am trying to use the same method for another DTS package, which executes five other packages. I've tried both the 'structured storage' and 'embedded in task' methods pointing to the parent package but in debugging mode the execution immedately fails. When I execute the parent package in Management Studio, it successfully executes the five child packages. I am including the debugging message below, thogh it doesn't help me any. Does anyone know what the problem is?

SSIS package "BPSA_LOAD_ACCT_SUMMARY_NEW.dtSX" starting.
Error: 0x0 at Execute DTS 2000 Package Task: System.Runtime.InteropServices.COMException (0x80040427): Execution was canceled by user.
at DTS.PackageClass.Execute()
at Microsoft.SqlServer.Dts.Tasks.Exec80PackageTask.Exec80PackageTask.ExecuteThread()
Task failed: Execute DTS 2000 Package Task
Warning: 0x80019002 at BPSA_LOAD_ACCT_SUMMARY_NEW: The Execution method succeeded, but the number of errors raised (1) reached the maximum allowed (1); resulting in failure. This occurs when the number of errors reaches the number specified in MaximumErrorCount. Change the MaximumErrorCount or fix the errors.
SSIS package "BPSA_LOAD_ACCT_SUMMARY_NEW.dtSX" finished: Failure.

My misunderstanding.

I realize now that I have to execute the 5 DTS 2000 package tasks in the one 2005 project.

execute dts 2000 failuer

I have used to the execute dts 2000 task in Visual Studio to successfully execute a structured storage file for a simple DTS package.

I am trying to use the same method for another DTS package, which executes five other packages. I've tried both the 'structured storage' and 'embedded in task' methods pointing to the parent package but in debugging mode the execution immedately fails. When I execute the parent package in Management Studio, it successfully executes the five child packages. I am including the debugging message below, thogh it doesn't help me any. Does anyone know what the problem is?

SSIS package "BPSA_LOAD_ACCT_SUMMARY_NEW.dtSX" starting.
Error: 0x0 at Execute DTS 2000 Package Task: System.Runtime.InteropServices.COMException (0x80040427): Execution was canceled by user.
at DTS.PackageClass.Execute()
at Microsoft.SqlServer.Dts.Tasks.Exec80PackageTask.Exec80PackageTask.ExecuteThread()
Task failed: Execute DTS 2000 Package Task
Warning: 0x80019002 at BPSA_LOAD_ACCT_SUMMARY_NEW: The Execution method succeeded, but the number of errors raised (1) reached the maximum allowed (1); resulting in failure. This occurs when the number of errors reaches the number specified in MaximumErrorCount. Change the MaximumErrorCount or fix the errors.
SSIS package "BPSA_LOAD_ACCT_SUMMARY_NEW.dtSX" finished: Failure.

My misunderstanding.

I realize now that I have to execute the 5 DTS 2000 package tasks in the one 2005 project.

|||I have small info about this problem. The real message in the DTS(2000) package log (but no in SSIS "Execute DTS 2000 Package Task" on SQL 2005 Server!) is:
"Step Error Source:
Step Error Description:(1:"My DTS 2000 Task Name") SubStep 'DTSStep_DTSExecutePackageTask_1' failed with the following error:
Exception of type 'System.OutOfMemoryException' was thrown.
Execution was canceled by user.Exception of type 'System.OutOfMemoryException' was thrown.
Step Error code: 80040427
Step Error Help File:
Step Error Help Context ID:0"
And this problem interrelated, as i any more know, with parallel execution of nested packages on DTS ("Execute on main package tread" option).
If you are yet interesting this problem - answer me there or email on sas72@.rambler.ru