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 |
|
Pinto
Aged Yak Warrior
590 Posts |
 Posted - 2007-02-12 : 10:19:02
|
| I want to import an Access table into a SQL table. Some of the integer Access fields have a null value, but when they are imported I want them to be 0 or zero in my SQL table. How can I do this please ? |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2007-02-12 : 10:24:26
|
| You can make a derived/calculated column and use COALESCE(SourceColumnNameHere, 0)Peter LarssonHelsingborg, Sweden |
 |
|
|
Pinto
Aged Yak Warrior
590 Posts |
Posted - 2007-02-12 : 10:27:22
|
| Do I do this in the Transform part of the DTS |
|
|
|
Pinto
Aged Yak Warrior
590 Posts |
Posted - 2007-02-12 : 10:55:05
|
| I did it another way - I used an update query on any null fields after it was imported into SqlThanks for your suggestions |
|
|
|
|
|
|
Import Access table using DTS