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 |
|
BigRetina
Posting Yak Master
144 Posts |
 Posted - 2006-01-01 : 21:22:17
|
| Hello,I am importing a text file into my database. I have a problem is that sometimes the value ####### might appear in one of the numerical columns in the file (the file is in fixed length columns style). This is causing me problems. I am a little bit new with DTS...How can I replace this value with zero fore xample?...The columns are many..i have 5 files...i dont want to do that on a column-to-column transformation basis..isnt there a find and replace thing here?thanks |
|
|
SamC
White Water Yakist
3467 Posts |
Posted - 2006-01-01 : 22:16:02
|
quote:
Originally posted by BigRetina
I am importing a text file into my database. I have a problem is that sometimes the value ####### might appear in one of the numerical columns in the file (the file is in fixed length columns style).
DTS your data into a temporary working table which can be processed by SQL statements before inserting the data into the target table.You'll have access to functions like ISNUMERIC to find columns containing ######## |
 |
|
|
mcarahul
Starting Member
11 Posts |
Posted - 2006-01-02 : 00:50:12
|
| Use ActiveX script in the transformation itself. You can also use conditions in the script. This will solve the purpose of "find and replace thing". |
|
|
|
|
|
|
replace characters