Viewing 15 posts - 6,451 through 6,465 (of 11,678 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.
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...
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.
September 20, 2012 at 3:49 am
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....
September 19, 2012 at 5:02 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...
September 7, 2012 at 3:21 am
For the retry requirement, you can also configure retry attempts in the SQL Server Agent job.
September 7, 2012 at 2:49 am
Viewing 15 posts - 6,451 through 6,465 (of 11,678 total)