Difference when running a DTS package
Tech-Archive recommends: Fix windows errors by optimizing your registry
Hi
I have a DTS package that imports some data into a database and when the
package it finishes with a mailtask that sends a mail on completion.
Some of my users run this DTS package with Enterprise Manager locally
installed, and som users execute the package with DTSRun run locally.
For the users running it with DTSRun, the mailtask executes like it should,
but for the users running the DTS pacje through enterprise Manager, they get
an error the MAPI profile.
How differs DTSRun with Enterprise Manager when it comes to execution of DTS
packages?
/A
.
Relevant Pages
- Re: "Failed" Job runs DTS package
... pulls new data from a database on a different server. ... Now the DTS Package completes, but the Job says it failed. ... DTSStep_DTSExecuteSQLTask_2 DTSRun OnFinish: ... DTSStep_DTSExecuteSQLTask_2 DTSRun OnStart: ... (microsoft.public.sqlserver.dts) - Re: Running Legacy DTS on x64 2005 cluster
... At the moment I'm trying to run it under the Legacy Data Transformation ... Is your dts package within the SSIS execute DTS package task, ... DTSRun OnStart: DTSStep_DTSDynamicPropertiesTask_1 ... ActiveX Scripting was not able to initialize the script execution ... (microsoft.public.sqlserver.dts) - DTSRUN privileges?
... I am trying to get a DTS package to be run from the command line with the dtsrun utility. ... The user I supply is a user in the database. ... It looks to me like the SQL Server instance does exist because it tries to start the package. ... (comp.databases.ms-sqlserver) - DTS FTP & Scheduling
... I created a simple DTS package which uses the FTP task in Enterprise ... I want to get a file off of the SQL Server D:\ Drive and copy ... When I manually execute the job it runs ... DTSStep_DTSExecutePackageTask_1 DTSRun OnProgress: ... (microsoft.public.sqlserver.dts) - Re: executing DTS packages
... I did a search for DTSRun in BOL. ... Utility in the Command Prompt Utilities. ... switches and options for the DTSRun command. ... > /N is for the Name of the DTS Package. ... (microsoft.public.access.adp.sqlserver) |
|