in

Pragmatic Works

Enabling your business intelligence enterprise.

Browse by Tags

  • Using RegEx in SSIS to Remove Given Characters

    In SSIS, we recently were engaged by a customer who had a fairly simple request. They wished to remove non-numeric items from a column in the data flow. They were doing this in a stored procedure by using a T-SQL replace function row-by-row and we wanted to make this a data flow instead due to speed...
    Posted to Brian Knight (Weblog) by Brian Knight on 06-03-2008
Page 1 of 1 (1 items)
Copyright Pragmatic Works
Powered by Community Server (Non-Commercial Edition), by Telligent Systems