SSIS: Trim the Join Fields for Merge Join

Categories: Database; Tagged with: ETL • SQL • SQL Server • SSIS; @ March 13th, 2013 19:37

Kindly remind you:

Do trim the join fields for your ‘MergeJoin’:

Otherwise it may take hours to debug!!

 

 

SELECT LTRIM(RTRIM(seccode)) AS seccode….

亚马逊已取消从账户注册Kindle设备的功能 <-> JIRA Error: Unexpected token UNIQUE, requires COLLATION in statement [SET DATABASE UNIQUE])

---

ActionScript Adobe AIR ANT Apache ApacheFlex Apache Flex Better Developer BlazeDS Cloud Computing CMD DataGrid DataGridColumn DB2 Derby DTSX Eclipse ETL Event Excel Flash Builder Flex Google Java JDBC JDK JIRA Life@SG|新加坡 Linux MySQL Oracle PHP Python RegEx Servlet SQL SQL Server SSIS SVN T-SQL Tools Tree Ugly WordPress XML dev-notes side-projects