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 |
|
Royal
Starting Member
32 Posts |
 Posted - 2007-02-24 : 14:50:27
|
| Hi!I have a Fact_ETL process with several Lookups. I need to compare a ID-string datatype DT_14 from OLE DB Source to string DT_18 from Dim_salesperson. Then I would collect the ID's from Dim_salesperson into OLE DB Destination. Tried to convert DT_14 to DT_18 before Lookup. No, not working. Decimal[DT_Decimal] not working either...I would be so grateful if someone could give an idea... |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2007-02-24 : 22:09:48
|
| Have you tried converting to character then to dt_18? Try using an expression to format it.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
Royal
Starting Member
32 Posts |
Posted - 2007-02-25 : 06:10:15
|
| First DT_14 to character. Secondly char to DT_18. By char you mean converting to DT_STR then DT_18 ?... |
|
|
|
Royal
Starting Member
32 Posts |
Posted - 2007-02-25 : 10:51:47
|
| Thanks, problem solved! |
|
|
|
|
|
|
Conversion