Tuesday, November 20, 2018

SSIS SQL Server Integration Services - convert string to number, replace special characters

SSIS SQL Server Integration Services - convert string to number, replace special characters

Type conversion

    1. Use data conversion component 
    2. Select desired type from data conversion component 

Replace special characters

1. Use delivered column component


2. Use formula expression to replace special charaters f.e REPLACE( [Target qty] , "-","0" )  replaces "-" with 0





at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

Problem with database open ORA-19804, ORA-19809, ORA-03113

1. Try to login to database with SYS AS SYSDBA user. If the instance is idle, run the startup command. 2. If ORA-03113 occured, check the la...