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 |
|
cutever
Starting Member
32 Posts |
 Posted - 2002-12-11 : 23:46:48
|
| I've designed a simple DTS, which will get the record from Excel file and import into the database table. I use that DTS to import 10 users record into the database, and get the result - import successfully (DTSRun Successful). However, when I use back the same DTS to import 1000 records, it prompt me the error as following: ----------------------------------------------------------------------DTSRun: Loading... DTSRun: Executing... DTSRun OnStart: DTSStep_DTSDataPumpTask_1 DTSRun OnError: DTSStep_DTSDataPumpTask_1, Error = 0 (0) Error string: Error during Transformation 'DTSTransformation__32' for Row number 124. Errors encountered so far in this task: 1. Error source: DTS Data Pump Help file: Help context: 0 Error Detail Records: Error: -2147352319 (80020101); Provider Error: 0 (0) Error string: Error Code: 0 Error Source= Microsoft OLE DB Provider for SQL Server Error Description: CryptoAPI function 'CryptAcquireContext' failed. Error 0x8009001d: (Error description unavailable). Error on Line 7 Error source: Microsoft Data Transformation Services (DTS) Data Pump Help file: sqldts80.hlp Help context: 30631 Error: -2147467259 (80004005); Provider Error: 0 (0) Error string: CryptoAPI function 'CryptAcquireContext' failed. Error 0x8009001d: (Error description unavailable). Error source: Microsoft OLE DB Provider for SQL Server Help file: Help context: 0 DTSRun OnError: DTSStep_DTSDataPumpTask_1, Error = -2147213206 (8004206A) Error string: The number of failing rows exceeds the maximum specified. Error source: Microsoft Data Transformation Services (DTS) Data Pump Help file: sqldts80.hlp Help context: 0 Error Detail Records: Error: -2147213206 (8004206A); Provider Error: 0 (0) Error string: The number of failing rows exceeds the maximum specified. Error source: Microsoft Data Transformation Services (DTS) Data Pump Help file: sqldts80.hlp Help context: 0 Error: -2147352319 (80020101); Provider Error: 0 (0) Error string: Error Code: 0 Error Source= Microsoft OLE DB Provider for SQL Server Error Description: CryptoAPI function 'CryptAcquireContext' failed. Error 0x8009001d: (Error description unavailable). Error on Line 7 Error source: Microsoft Data Transformation Services (DTS) Data Pump Help file: sqldts80.hlp Help context: 30631 Error: -2147467259 (80004005); Provider Error: 0 (0) Error string: CryptoAPI function 'CryptAcquireContext' failed. Error 0x8009001d: (Error description unavailable). Error source: Microsoft OLE DB Provider for SQL Server Help file: Help context: 0 DTSRun OnFinish: DTSStep_DTSDataPumpTask_1 DTSRun: Package execution complete. NULL----------------------------------------------------------------------Could anyone please help me on this, and tell me what error is it, what is "CryptoAPI function 'CryptAcquireContext' failed" and how to expand its maximum number specified ("The number of failing rows exceeds the maximum specified")? Thank You very much !Ver |
|
|
Page47
Master Smack Fu Yak Hacker
2878 Posts |
Posted - 2002-12-12 : 07:22:05
|
| You could start by logging the error rows and take a look at what it doesn't like.Jay White{0} |
 |
|
|
|
|
|
DTSRun OnError