SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2005 Forums
 SSIS and Import/Export (2005)
 Special Characters
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Brittney10
Posting Yak Master

USA
145 Posts

Posted - 12/10/2012 :  10:05:47  Show Profile  Reply with Quote
How do i remove all special characters from a column? There's got to be a better way than using Replace for each special character?

sodeep
Flowing Fount of Yak Knowledge

USA
7174 Posts

Posted - 12/10/2012 :  10:37:05  Show Profile  Reply with Quote
Won't front end be able to handle that? You can search for function to remove it and then use it.
Go to Top of Page

Brittney10
Posting Yak Master

USA
145 Posts

Posted - 12/10/2012 :  10:51:54  Show Profile  Reply with Quote
I need to be able to remove the special characters in the data flow before inserting the record. I'm just trying to determine the most effective way to do this. I can do a replace on the column using a derived data flow transformation, but it seems as though there is a better way to do this...It can be done in a script as well, but my scripting skills are lacking a bit. Basically it comes down to Derived data flow or script task from what I'm reading, but which is the best method to achieve the results I'm wanting?
Go to Top of Page

Brittney10
Posting Yak Master

USA
145 Posts

Posted - 12/10/2012 :  17:21:53  Show Profile  Reply with Quote
I ended up doing a REPLACE on the characters I needed...the script task would only work by storing an array of characters to remove. Ultimately, a reg. expression will work and is just as efficient as a script task (though the code is not as pretty).
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.05 seconds. Powered By: Snitz Forums 2000