Viewing 15 posts - 6,991 through 7,005 (of 11,678 total)
Grant Fritchey (6/4/2012)
michaeljharper (6/4/2012)
GilaMonster (6/4/2012)
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...
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.
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...
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...
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....
June 4, 2012 at 1:42 am
Is user account control turned off on your new laptop?
June 4, 2012 at 1:32 am
Euhm... what exactly do you mean?
Job opportunities?
The opportunity to play with new features?
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.
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...
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...
June 4, 2012 at 12:05 am
jayani0507 (6/3/2012)
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...
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.
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...
June 2, 2012 at 2:38 pm
Viewing 15 posts - 6,991 through 7,005 (of 11,678 total)