Very Computer

Hi,
I got a DTS that runs fine when executed manually.
When scheduling this DTS with a job, the job fails, returning the following
message , in the job history log:

...   DTSRun:  Executing...   DTSRun OnStart:  DTSStep_DTSExecuteSQLTask_1
DTSRun OnStart:  DTSStep_DTSDataPumpTask_4   DTSRun OnStart:
DTSStep_DTSDataPumpTask_6   DTSRun OnStart:  DTSStep_DTSDataPumpTask_2
DTSRun OnError:  DTSStep_DTSExecuteSQLTask_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:  Multiple-step OLE DB operation
generated errors. Check each OLE DB status value, if available. No work was
done.  ...  Process Exit Code 24.  The step failed.

Whta does it mean?

Note: other DTS's run fine in jobs - it just one specific DTS's

We are running SQL7, SP3 on server and all workstations running SQL.

Thanks

Hi,
What is the source of data for your DTS package. Is it
referring to mapped drives. Please take a look at article
Q269074 on support.microsoft.com

Bye
Ramdas

Quote:>-----Original Message-----
>Hi,
>I got a DTS that runs fine when executed manually.
>When scheduling this DTS with a job, the job fails,

returning the following

Quote:>message , in the job history log:

>....   DTSRun:  Executing...   DTSRun OnStart:  

DTSStep_DTSExecuteSQLTask_1

Quote:>DTSRun OnStart:  DTSStep_DTSDataPumpTask_4   DTSRun
OnStart:
>DTSStep_DTSDataPumpTask_6   DTSRun OnStart:  

DTSStep_DTSDataPumpTask_2

Quote:>DTSRun OnError:  DTSStep_DTSExecuteSQLTask_1, Error = -

2147217887 (80040E21)

Quote:>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:

Quote:>Error:  -2147217887 (80040E21); Provider Error:  0

(0)      Error string:

Quote:>The property 'Use Encryption for Data' is not

supported.      Error source:

Quote:>Microsoft Data Transformation Services (DTS) Package      
Help file:
>sqldts.hlp      Help context:  1100         Error:  -

2147217887 (80040E21);

Quote:>Provider Error:  0 (0)      Error string:  Multiple-step
OLE DB operation
>generated errors. Check each OLE DB status value, if

available. No work was

Quote:>done.  ...  Process Exit Code 24.  The step failed.

>Whta does it mean?

>Note: other DTS's run fine in jobs - it just one specific
DTS's

>We are running SQL7, SP3 on server and all workstations
running SQL.

>Thanks

>.

Yossi,

Check the version of MDAC of the client machines and the server itself. It
would appear that the client machine has MDAC 2.6 and the server has
somethis earlier.

Rand Boyd
Microsoft SQL Server Support

You can view any Microsoft Knowledge Base aricle by entering mskb <article
number> in the URL  line in Internet Explorer.

Please reply only to the newsgroups.
When posting, please state the version of SQL Server being used and the
error number/exact error  message text received, if any.

This posting is provided AS IS, with no warranties, and confers no rights.

It's seems to be it...
Thanks

Quote:> Yossi,

> Check the version of MDAC of the client machines and the server itself. It
> would appear that the client machine has MDAC 2.6 and the server has
> somethis earlier.

> Rand Boyd
> Microsoft SQL Server Support

> You can view any Microsoft Knowledge Base aricle by entering mskb <article
> number> in the URL  line in Internet Explorer.

> Please reply only to the newsgroups.
> When posting, please state the version of SQL Server being used and the
> error number/exact error  message text received, if any.

> This posting is provided AS IS, with no warranties, and confers no rights.