 | |
Remove commas during data transfer?
microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts
 |
| | Thread Tools | Display Modes |
#1
 
| |||
| |||
|
Remove commas during data transfer? -
03-11-2005
, 01:27 PM
#2
| |||
| |||
|
|
I have some tables that keep failing when I try to copy them to another SQL server using DTS. I've identified a pattern that the first failing row in the problem tables always has a comma in one of the nvarchar fields. I'd like to try to write a dts package that would filter out all the commas. I'd appreciate any pointers on exactly how to do this. Wayne |
#3
| |||
| |||
|
|
What datatype are you going from and to? SQL Server --> SQL Server? REPLACE() would get rid of commas "Wayne Wengert" <wayneDONTWANTSPAM (AT) wengert (DOT) com> wrote in message news:wayneDONTWANTSPAM (AT) wengert (DOT) com: I have some tables that keep failing when I try to copy them to another SQL server using DTS. I've identified a pattern that the first failing row in the problem tables always has a comma in one of the nvarchar fields. I'd like to try to write a dts package that would filter out all the commas. I'd appreciate any pointers on exactly how to do this. Wayne |
|
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2013, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2013, Jelsoft Enterprises Ltd.