Left Join Merge problem

Hot Topic

accessing report server programmatically
SQL Server Management
Partition Index Probelm when Switching a partition in
What interface does Management Studio use?
CSV Exports are not as expected, columns are missing
Error returning OLAP data in RS 2005
CLR Stored Procedure Exception Handling
How connect SQL server 2000 with c#.net .....?
Consume HTTP EndPoint
Help with Page Breaks and large amount of text...

SQL Server

.dtsConfig ConfiguredValue contains environment variable?
Sql Server 2005 Mobile/RDA connection problem
an insert
Complex SQL Query
not possible to export from the Report Viewer control -Error
2005 Query help
Importing unicode data from Oracle Database
Visual C# cannot connect to SQL 2005 Express
my store procedure that call back itself doesn't seems to work.
Report Builder - A filter is required

Left Join Merge problem

I am having a problem getting the left join merge to work when I attempt to join data that was staged from an Oracle database using the Microsoft OLEDB provider for Oracle with data from an SQL Server 2000 database.  I'm sorting and merging on 2 varchar columns and they never join.  Visually, the data looks like it should join and I can successfully join it in an SQL statement from Query analyzer. 

Any ideas



Answer this question

Left Join Merge problem

  • Josamoto80

    I did try creating derived columns with the trim function, but to no avail. 

    The codepage problem you mentioned may be the real issue.  When I stage the data into the SQL Server 2000 database from Oracle, DTS 2005 displays a warning about possible codepage issues because its unable to read the codepage from the Oracle database and therefore uses a default codepage.  If this is the case, what would be the remedy   I'm also puzzled as to why I can successfully join the data in a standard SQL statement within query analyzer. 


  • CarlBrochu

    Without seeing the data I can't be sure, but my guess would be padding spaces at the end of the column's data (e.g. '1234567890' does not equal '1234567890 ').  You might want to add a trim to the sql statement that is loading the column or add a derived column and trim the column data before it gets to the merge and see if that solves your problem.  It could also be codepage issues (since strings are promoted to Unicode before comparison).

    Thanks,

  • erico maia

    This actually was noise, there were other errors that I initially was not seeing.  These errors were real errors and once fixed the process ran. 

    Smile

  • vibinpranav

    Ken, Did you figure out a method to ignore the warning or make the codepages match up   I have a similiar situation and in SSIS on 2005 the warnings are stopping my going forward.  If I do a preview I am able to ignore the warnings and pull the data from the Oracle side, but in process mode it tries 5 times then stops.

    Thanks;
    Mark
  • Left Join Merge problem
Answer this question