Viewing 15 posts - 6,991 through 7,005 (of 11,676 total)
Grant Fritchey (6/4/2012)
michaeljharper (6/4/2012)
GilaMonster (6/4/2012)
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
June 4, 2012 at 2:23 pm
Thanks everyone for their responses so far.
@robert: I cleaned the caches with the following statements:
DBCC DROPCLEANBUFFERS;
DBCC FREEPROCCACHE;
I'll add the CHECKPOINT command to this statements in the future.
The simple...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
June 4, 2012 at 2:07 pm
Put both tasks in one sequence container and put the TransactionOption to Required.
Make sure MSDTC (Microsoft Distributed Transaction Coordinator) is enabled and configured.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
June 4, 2012 at 7:19 am
sestell1 (6/4/2012)
Interesting... so you have to roll back an entire project even if you only need a previous version of a single package?
For the moment this seems to be the...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
June 4, 2012 at 7:13 am
So I had this lovely beer this weekend:

It's Grimbergen aka "the beer of the feniks" in it's blonde version.
It's an abbey beer and brewed by Alken Maes (not really my...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
June 4, 2012 at 1:52 am
I'm don't know how it is in your country, but in Belgium a Masters degree can give you an advantage.
However, this advantage is mostly at the beginning of your career....
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
June 4, 2012 at 1:42 am
Is user account control turned off on your new laptop?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
June 4, 2012 at 1:32 am
Euhm... what exactly do you mean?
Job opportunities?
The opportunity to play with new features?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
June 4, 2012 at 1:26 am
If you are using Database --> Tasks --> Generate scripts, you have a similar options screen where you can define all scripting options.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
June 4, 2012 at 1:22 am
Imran Ashraf-452633 (6/4/2012)
On your link provided it is stating something different.http://msdn.microsoft.com/en-us/library/hh479588.aspx
The objects that are stored in the SSISDB catalog include projects, packages, parameters, environments, and operational history.
There's a difference between...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
June 4, 2012 at 12:50 am
This is another article about Sequences that just repeats everything on MSDN.
What I really would like to see is an article showing us what we can actuallo DO with the...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
June 4, 2012 at 12:05 am
jayani0507 (6/3/2012)
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
June 3, 2012 at 1:09 pm
Perry Whittle (6/3/2012)
Develop locally and use package variables, you can then update the connections when deploying to live
It's not enough if the metadata changes during deployment (which is the issue...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
June 3, 2012 at 1:08 pm
No problem, glad to help.
Remember to run the package also in 32-bit mode on the server if you also installed the 32-bit provider there.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
June 2, 2012 at 2:39 pm
Stefan Krzywicki (6/1/2012)
I'd suggest getting the Attunity connector for Oracle. It seems to work better/faster for me than any of the standard objects for connecting to Oracle. They're free.
+1
And already...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
June 2, 2012 at 2:38 pm
Viewing 15 posts - 6,991 through 7,005 (of 11,676 total)