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 |
|
fmardani
Constraint Violating Yak Guru
433 Posts |
 Posted - 2005-07-05 : 04:35:05
|
| How do you convert the Source field to varchar or string since my destination field is varchar(10)Thanks//**********************************************************************// Java Transformation Script//************************************************************************// Copy each source column to the destination columnfunction Main(){ DTSDestination("ManagerID") = DTSSource("managerID"); return(DTSTransformStat_OK);} |
|
|
Kristen
Test
22859 Posts |
Posted - 2005-07-05 : 05:53:03
|
| Append a blank string?Kristen |
 |
|
|
fmardani
Constraint Violating Yak Guru
433 Posts |
Posted - 2005-07-05 : 05:56:16
|
| Could you please modify this as required?Thanks |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2005-07-05 : 06:11:03
|
| I think Kristen meant DTSDestination("ManagerID") = '' & DTSSource("managerID");MadhivananFailing to plan is Planning to fail |
|
|
|
|
|
|
convert