February 7, 2018 at 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
February 7, 2018 at 8:21 am
dopydb - Wednesday, February 7, 2018 8:07 AMhii 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 completei 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.
February 7, 2018 at 8:23 am
You haven't provided nearly enough information to even begin to answer this.
Drew
J. Drew Allen
Business Intelligence Analyst
Philadelphia, PA
February 7, 2018 at 9:30 am
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