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 - 2001-07-04 : 08:52:19
|
| Chris writes "i use cmdshell + dtsrun to execute a packageservice pack 3 for sqlserver loadedexample EXEC master..xp_cmdshell 'dtsrun /S server1 /U sa /P xxx /N test 'use sql server 2000 encryption box not marked transform table to text fileIs there other encryption propertiesi get following erroroutput --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- DTSRun: Loading...DTSRun: Executing...DTSRun OnStart: DTSStep_DTSDataPumpTask_1DTSRun 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" |
|
|
|
|
|
dts