Hi There,

SQL Server 7 on W2kAdv srv.
I already off the "use SQl server 2000 encryption" when
save the DTS. and directly run dts successful. but use
dtsrun /S** /U** /P** /N **, I got following error message:

Thanks
Bruce
------------
DTSRun: Loading... DTSRun: Executing... DTSRun
OnStart: DTSStep_DTSExecuteSQLTask_2 DTSRun OnError:
DTSStep_DTSExecuteSQLTask_2, 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_DTSExecuteSQLTask_2 DTSRun:
Package execution complete. Process Exit Code 1. The
step failed.

Hi

I think this is the option on the advanced properties of the connection.

John

"Bruce zhu" <zhuqi_zhuqi (AT) yahoo (DOT) com> wrote

This could be due to MDAC differences. Encryption was introduced in MDAC
2.5 so running a package built on a box with 2.5 or greater on a box with <
2.5 will cause this

http://support.microsoft.com/?kbid=255900



--


Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org




"Bruce zhu" <zhuqi_zhuqi (AT) yahoo (DOT) com> wrote

I had similar from on system that had originally created a
pkg but could no longer execute or design. I reverted
back to an earlier version to run the pkg to get through
that days tasks.

I then updated the security patches SQL sp's and MDAC on
that Win98 system and viola' that solved, I'm guessing
that it was the MDAC.

HTH

JeffP....

In article <003b01c39070$44076ca0$a001280a (AT) phx (DOT) gbl>, Bruce zhu
<zhuqi_zhuqi (AT) yahoo (DOT) com> writes
Sounds like this-

The property 'Use Encryption for Data' is not supported
(http://www.sqldts.com/default.aspx?227)

--
Darren Green (SQL Server MVP)
DTS - http://www.sqldts.com

PASS - the definitive, global community for SQL Server professionals
http://www.sqlpass.org