"Use Encryption for Data" error when running a job

[NeeNee]

I have a package which runs perfectly as a DTS package, but when I try to schedule it, it fails and generates the following error;

... DTSRun: Executing... DTSRun OnStart: DTSStep_DTSExecuteSQLTask_1 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. Error source: Microsoft OLE DB Provider for SQL Server Help file: Help context: 0 DTSRun OnFinish: DTSStep_DTSEx... Process Exit Code 1. The step failed.


I tried recreating the package from scratch and adding a job manually, but I always get the same error.
Does anyone know what the error means?

 

[JayKusch]

This error is due to different versions of the Microsoft Data Access Components (MDAC) across machines. For example MDAC 2.5/2.6 supports 'Use Encryption for Data', but lower versions do not.

To workaround re-save the package from a machine with the lower version of MDAC. This will remove the new unsupported


Thanks

J. Kusch

 

[JayKusch]

Sorry ... fat fingers hit the return before I was ready. Should have read ...

This error is due to different versions of the Microsoft Data Access Components (MDAC) across machines. For example MDAC 2.5/2.6 supports 'Use Encryption for Data', but lower versions do not.

To workaround re-save the package from a machine with the lower version of MDAC. This will remove the new unsupported
properties.


Thanks

J. Kusch