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 |
|
ocp_aman
Starting Member
1 Post |
 Posted - 2009-04-28 : 02:28:43
|
| I am using EXCEL Source in SSIS to write a following query to pick the data from excel file as. I want to replace - in a zip with nothingFor eg Zip 5214-0000 to 52140000select replace(zip, '-', '')from [sheet1$]Query is parsing but when i try to preview it saysUndefined function 'Replace' in expression. Can anybody tell me what is the solution. |
|
|
rhysmeister
Starting Member
6 Posts |
Posted - 2009-04-28 : 10:08:14
|
| What are you placing that query into? The Excel Source Component?If so this will not support T-SQL as it is outside the SQL Server Engine. You probably want to use a "Derived Column" component to transform data in the pipeline, or import it straight into SQL Server then transform it with T-SQL.Twitter Integration | Ping.fm Integration | SQL Server Blog |
 |
|
|
|
|
|
SSIS