Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-02-25 : 09:02:30
|
| Will writes "When we manually execute my DTS (DTS includes an import to tables and call to stored procedures) it works. However, when we schedule a job for it, it returns an error. Here is the error statement we receive:DTSRun: Loading... DTSRun: Executing... DTSRun OnStart: DTSStep_DTSDataPumpTask_1 DTSRun OnError: DTSStep_DTSDataPumpTask_1, Error = -2147217887 (80040E21) Error string: The property 'Use Encryption for Data' is not supported. Error source: Microsoft Data Transformation Services (DTS) Package Help file: sqldts.hlp Help context: 1100 Error Detail Records: Error: -2147217887 (80040E21); Provider Error: 0 (0) Error string: The property 'Use Encryption for Data' is not supported. Error source: Microsoft Data Transformation Services (DTS) Package Help file: sqldts.hlp Help context: 1100 Error: -2147217887 (80040E21); Provider Error: 0 (0) Error string: Errors occurred Error source: Microsoft OLE DB Provider for SQL Server Help file: Help context: 0 DTSRun OnFinish: DTSStep_DTSDataPumpTask_1 DTSRun: Package execution complete. Process Exit Code 1. The step failed.We do not make use of any encrypted variables. Thanks.Will" |
|
|
Tigger
Yak Posting Veteran
85 Posts |
Posted - 2002-02-25 : 14:38:12
|
| When a DTS package is run manually it runs on your pc and uses the network connections as they are set up on your pc. It also runs under your account.When a DTS package is scheduled it runs on the server and uses the network connections as they are set up on the server. It runs under the user account for SQL Server Agent.Most of the problems I've had with scheduled DTS not working have been due to either different network connections on my pc and the server or different access permission between my account and the user account for SQL Server Agent.What version of SQL are you using? I know with SQL 7 when I created a DTS package on my pc and add a connection to the server, I had to specify the servers network name (eg NTPRRP12) however for it to run on the server I had to go onto the server and change the connection to connect to the server as local. It did not recognise NTPRRP12.I would try running the package manually on the server itself. Once you can get that working, try scheduling it. If it fails then it's probably access permissions. |
 |
|
|
chadmat
The Chadinator
1974 Posts |
Posted - 2002-02-25 : 15:09:32
|
| Make sure the versions of MDAC are the same on you rclient and server.-Chad |
|
|
|
|
|
|
DTS Run