Home Forums Data Warehousing Integration Services Sum with negative number issue RE: Sum with negative number issue

  • February 7, 2018 at 8:21 am

    #1978904

    dopydb - Wednesday, February 7, 2018 8:07 AM

    hi

    i have a ssis package which has worked fine, until we introduced negative numbers to the spreadsheet it reads and manipulates,
    it seems the merge join function now has drastically increased in time to complete 

    i am using sql 2005 and vs 2005

    anyone any ideas?

    mal

    My recommendation would be that you do joins in SQL Server rather than SSIS, if you can, unless you are dealing with very small data sets.

    If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.