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 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.
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 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply