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 - 2007-03-02 : 08:47:36
|
| Caterina writes "HiI have a DTS package that transfers data from a staging table to a fact table.The DTS carries out a number of lookups. They all work fine individually, but when I try to execute the entire DTS it comes back with the following message:The number of failing rows exceeds the maximum specified.ActiveX Scripting Transform 'DTSTransformation_4' encountered an invalid data value for 'CurrencyKey' destination column.Help?Caterina" |
|
|
JohnH
Starting Member
13 Posts |
Posted - 2007-03-12 : 13:12:45
|
| When this happens to me, it generally turns out that either:1. My source data wasn't as clean as I thought/hoped.2. I goofed and the source and destination data types aren't compatible.HTH,JohnJohn Hopkins |
 |
|
|
|
|
|
Invalid Data Value for DTS Destination Column