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 |
|
rajantonyv
Starting Member
12 Posts |
 Posted - 2005-03-15 : 10:10:53
|
| Hi,I have a text file being downloaded from the mainframe during a certain timeframe and within that spreadsheet there are double quotes and commas. Those double quotes are preventing me from automatically load this into the table. So I am trying to replace doublequotes in a text file with no value or null. Here is my DTS script but I am getting an expected ')' error message:Function Main() DTSDestination("Col009") = Replace(DTSSource(""CHCK""), """", "") DTSDestination("Col008") = Replace(DTSSource(""ASTT""), """", "") DTSDestination("Col007") = Replace(DTSSource(""OTRT""), """", "") DTSDestination("Col006") = Replace(DTSSource(""HRLY""), """", "") DTSDestination("Col005") = Replace(DTSSource(""WRK#""), """", "") DTSDestination("Col004") = Replace(DTSSource(""KEY""), """", "") DTSDestination("Col003") = Replace(DTSSource(""FRST""), """", "") DTSDestination("Col002") = Replace(DTSSource(""LAST""), """", "") DTSDestination("Col001") = Replace(DTSSource(""EEID""), """", "") Main = DTSTransformStat_OKEnd FunctionThanksRajesh Antony Vattakunnel |
|
|
|
|
|
|
|
Replacing Double Quotes In A Text File Using DTS