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 |
|
blindsey
Starting Member
2 Posts |
 Posted - 2008-12-15 : 15:15:28
|
| I'm getting errors trying to import from MS Access.The offending values are represented in Access as "1.#INF" which seems to be an "infinite" value, presumably an overflow from a mathematical operation.I've tried changing the target data type from float to nvarchar and some others but I still get an overflow error.Any way I can handle this gracefully and transform these values into something unique without errors? |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-12-16 : 00:03:57
|
| try using conditional transformation and transform these values to some other varchar value like 'unknown' or 'infinite' |
 |
|
|
blindsey
Starting Member
2 Posts |
Posted - 2008-12-16 : 08:54:46
|
quote:
Originally posted by visakh16
try using conditional transformation and transform these values to some other varchar value like 'unknown' or 'infinite'
Is this in the DTS setup? i can't find where to do this. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-12-16 : 10:44:41
|
| Add a transform data task and inside this you can add different types of transformations,select conditional transformation |
|
|
|
|
|
|
Problem importing from MS Access