Viewing 15 posts - 31 through 45 (of 579 total)
krishnaroopa (1/13/2011)
Recently we replaced cursors with while loop and table variables.
You didn't really. Looping over a tableset is a cursor in disguise.
January 13, 2011 at 5:13 am
SBS-291204 (11/24/2009)
Mate, I think you'll find Jamie Thomson is a man... unless he's not telling us something?
Thank you man! 🙂
I didn't know about this article until yesterday evening when Siddharth...
November 27, 2009 at 2:30 am
Adrian,
I moved temporarily (to the US) but it was all handled by my company so its not really relevant for you.
Once I'd applied for my Visa (paperwork was done by...
July 14, 2008 at 9:13 am
Consistency breeds quality. Consistency IS quality. You don't get quality without consistency.
You can have 3 incredibly bright developers but if they aren't adhering to some simple, documented, consistent standards then...
May 16, 2008 at 3:34 am
rana (3/1/2007)
Setting AlwaysUseDefaultCodePath="TRUE" will cause this error to go away
This works fine with oledbsource and destination.
I am using Oracle Provider for OLE DB 10.2.0.2.20.
One more problem i am...
March 21, 2008 at 10:56 am
Regan Galbraith (2/29/2008)
Jamie Thomson (5/1/2006)
Carol,
Absolutely not. SSIS process data in the pipeline wthin memory buffers. The size of each buffer is determined at runtime and as many buffers as are...
February 29, 2008 at 8:03 am
Yeah one small thing to add. Automating incremental deploys worries me because I would rather have a human being involved in that process because there are simply some things that...
February 11, 2008 at 7:38 am
tymberwyld (2/10/2008)
February 11, 2008 at 1:49 am
tymberwyld (2/10/2008)
Grant Fritchey (2/7/2008)
February 10, 2008 at 9:35 am
djedgar (2/4/2008)
Let’s evaluate
-Forward changes to test environment If this means its possible to promote code...
February 4, 2008 at 3:00 pm
djedgar (2/4/2008)
To answer the second part of your query first, the decision to implement as a dataflow rather than use the T-SQL in a stored procedure or in a SQL...
February 4, 2008 at 8:59 am
Nick Maroudas (2/4/2008)
To answer the second part of your query first, the decision to implement as a dataflow rather than use...
February 4, 2008 at 7:45 am
tymberwyld (2/4/2008)
February 4, 2008 at 6:31 am
Interesting. You say that this improved 10 minutes from using a Merge Join - that doesn't surprise me. I'd be more interested in knowing if there is a performance improvement/degredation...
February 4, 2008 at 6:27 am
Grant Fritchey (1/24/2008)
We're using this tool more and more because it really is fantastic. But, because we use it more and more, all the little gotcha's get magnified.
Amen to that....
January 24, 2008 at 8:12 am
Viewing 15 posts - 31 through 45 (of 579 total)