Viewing 15 posts - 9,991 through 10,005 (of 13,874 total)
mmartin1 (4/11/2013)
I don't believe the forum users in general like the idea of clicking on obscure links.
+1, I'm not game for that either!
April 12, 2013 at 12:59 am
SSIS is extremely fast at INSERTs - I'd suggest leaving those to SSIS.
Updates and deletes I would direct to a staging area and then MERGE via a T-SQL stored proc.
I...
April 12, 2013 at 12:58 am
GilaMonster (4/11/2013)
April 11, 2013 at 5:21 am
Maybe this[/url] article explains it.
Your GETDATE() function is being re-evaluated many times - your faster solution avoids this.
April 11, 2013 at 4:20 am
jdbrown239 (4/10/2013)
April 10, 2013 at 9:13 am
jdbrown239 (4/10/2013)
When I exported the data from the sql table (93,456 rows) to a txt file and then imported it...
April 10, 2013 at 7:04 am
Are there duplicate rows (by PK) in the source data?
April 9, 2013 at 2:22 pm
What results do you want to see, based on your sample data?
April 9, 2013 at 3:58 am
andrewalex.r (4/8/2013)
17921Task Completed ...
April 9, 2013 at 12:49 am
opc.three (4/8/2013)
April 9, 2013 at 12:46 am
rajeshk 36156 (4/8/2013)
"CWBZZ5014 Value of parameter columnName could not be converted to the host data type."."CWBNL0107 - Converted 80 bytes, 2 errors found beginning at...
April 8, 2013 at 6:51 am
What is the text of the error message?
April 8, 2013 at 6:28 am
It should work. Have you tried setting a pre-execute breakpoint on the task to ensure that the value in the variable is exactly what you are expecting?
April 8, 2013 at 4:22 am
This is not easy without knowing more about your data and table structures.
Please follow the link in my signature to see how to post easily consumable DDL and sample data.
April 8, 2013 at 3:13 am
Could the fact that 'Destination' is spelt incorrectly in the following be a factor, or is it just a typing error?
"Access to the path 'D:\Destinaion' is denied."."
April 8, 2013 at 1:39 am
Viewing 15 posts - 9,991 through 10,005 (of 13,874 total)