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 - 2002-02-11 : 08:55:40
|
| Kevin writes "I am attempting to import an Excel spreadsheet -- all columns get imported OK except for the cells with Excel types of currency and date.Here's the transformation code I tried for the currency types: If IsNull(DTSSource("lprice")) Then DTSDestination("lprice") = DTSSource("lprice") Else DTSDestination("lprice") = CStr(DTSSource("lprice")) End IfDTS says the import is successful but no data gets copied for this column (or the dates).Am I correct to convert the currency to a string?If not what should I use?" |
|
|
|
|
|
DTS Transformation script for currency types