Sum with negative number issue

  • 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

  • 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 the answer to your question can be found with a brief Google search, please perform the search yourself, rather than expecting one of the SSC members to do it for you.
    See https://www.sqlservercentral.com/articles/forum-etiquette-how-to-post-datacode-on-a-forum-to-get-the-best-help/ for details of how to post T-SQL code-related questions.

  • You haven't provided nearly enough information to even begin to answer this.

    Drew

    J. Drew Allen
    Business Intelligence Analyst
    Philadelphia, PA

  • apols, i really have posted a bad question in a rush

    ill be back with a revised post

Viewing 4 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply