When I execute a SQL package using a passthough query in Access 97 I get the following error message:
DTSRun OnError: DTSStep_DTSDataPumpTask_6, 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
Does anyone know the cause of the message "Use Encryption for Data' is not supported."? Originally this message did not appearand the package worked fine through Access 97. Now this message is displaed as an error and the package does not want to execute.
I would be greatful for any answers.hints/tips on this matter.