Viewing 15 posts - 6,451 through 6,465 (of 11,676 total)
It depends on the load of your package and what you exactly do in the package, but I don't think you'll see much difference.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
September 20, 2012 at 3:54 am
Your mistake is in using the OLE DB Command for doing updates, which is very, very slow.
Try writing the rows to a staging table and do an UPDATE using TSQL...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
September 20, 2012 at 3:51 am
There are already some books available on SSIS 2012. For example: http://www.amazon.com/Professional-Microsoft-Server-Integration-Services/dp/111810112X/ref=sr_1_1?ie=UTF8&qid=1348134557&sr=8-1&keywords=ssis+2012
There's also the free e-book Introducing MS SQL Server 2012 which contains some chapters about SSIS, DQS and MDS.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
September 20, 2012 at 3:49 am
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
September 20, 2012 at 3:45 am
Easy one, thanks.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
September 19, 2012 at 11:47 pm
jcrawf02 (9/19/2012)
L' Eomot Inversé (9/18/2012)
Evil Kraig F (9/18/2012)
Does EXCEL handle that many columns? I didn't think it did (well, reasonably anyway) but I've certainly been inaccurate before.
No, it doesn't....
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
September 19, 2012 at 5:02 am
Nice question, thanks.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
September 19, 2012 at 4:42 am
Nice question, thanks.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
September 18, 2012 at 1:48 am
Easy one, thanks.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
September 17, 2012 at 11:40 pm
Nice question, thanks.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
September 17, 2012 at 12:50 am
Great question, thanks!
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
September 17, 2012 at 12:08 am
Nice question, thanks.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
September 10, 2012 at 11:34 pm
Easy monday question, thanks!
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
September 10, 2012 at 2:05 am
Michael Lysons (9/7/2012)
Then again, "Is GO x valid T-SQL?" would be a boring question.🙂
And the answer is surprisingly: no.
GO is not a TSQL statement, but a batch terminator recognised by...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
September 7, 2012 at 3:21 am
For the retry requirement, you can also configure retry attempts in the SQL Server Agent job.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
September 7, 2012 at 2:49 am
Viewing 15 posts - 6,451 through 6,465 (of 11,676 total)