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 |
|
DaveRolph
Starting Member
15 Posts |
 Posted - 2006-02-19 : 02:58:56
|
| Is there such a command (or a simple example) so that I can add my inserts and propercase ?Example My Existing line DTSDestination("Name") = DTSSource("Name")I would like the following examples to work....MR DAVE ROLPH - Mr Dave RolphMRS D ROLPH - Mrs D RolphMR D O'CONNEL - Mr D O'ConnelMr MCDONALD - Mr McDonaldYeah OK the last one may be hard but not the end of the world if I can't do it ! |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
|
|
DaveRolph
Starting Member
15 Posts |
Posted - 2006-02-19 : 06:27:59
|
| Thanks for the reply, I see I can do it using a custom function but I wanted to do it within the DTS Package. |
 |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2006-02-19 : 07:13:31
|
| Create a stored procedure to do this. Run it within in your DTS.----------------------------------'KH'Time is always against us |
|
|
|
DaveRolph
Starting Member
15 Posts |
Posted - 2006-02-19 : 07:48:44
|
| Thanks again, but would this mean re-processing the SP at the end of the DTS script or do you mean within the ActiveX Script ? If the latter could you please provide an example ? |
|
|
|
|
|
|
Proper Case