Viewing 15 posts - 10,081 through 10,095 (of 11,678 total)
adam spencer (2/22/2011)
I mean I have to be able to access it in SSIS from a connection from server2. I would be SUPER...
February 22, 2011 at 11:48 pm
ns.sharath (2/22/2011)
Is there any workaround for the blockage due to update, not allowing any insert.
Do a set based insert with the OLE DB Destination Fast Load. Write the updates to...
February 22, 2011 at 11:36 pm
navecomp (2/22/2011)
February 22, 2011 at 12:06 pm
Craig Farrell (2/22/2011)
Koen Verbeeck (2/22/2011)
Craig Farrell (2/22/2011)
You create a foreach loop (the way...
February 22, 2011 at 12:02 pm
I've done the MCTS BI exam in November 2010 and the MCITP BI exam this January, and I didn't notice anything abnormaly difficult. Maybe different region equals different questions?
February 22, 2011 at 11:59 am
Maybe there is a blocking issue because you are updating and inserting in the same table at the same time, while one of the processes has a table lock?
February 22, 2011 at 11:56 am
Check the properties of the connection manager. There is a property ConnectionString. Look into that one, it normally has the provider listed.
February 22, 2011 at 11:52 am
Craig Farrell (2/22/2011)
You create a foreach loop (the way that's built in to...
February 22, 2011 at 11:51 am
george sibbald (2/22/2011)
my other point would be the monitor can be installed on the secondary server.......:-)
Let's just conclude that the question could have been phrased better 🙂
February 22, 2011 at 7:01 am
george sibbald (2/22/2011)
Koen Verbeeck (2/22/2011)
mohammed moinudheen (2/21/2011)
Not in Primary should also be correct.
That is not true.
Not in Primary is the same as saying: on every server that is not the...
February 22, 2011 at 6:52 am
GilaMonster (2/21/2011)
P.S. in a well run environment developers have no rights at all to production. Anything else is asking for chaos and trouble.
I'd argue to give the ETL team read...
February 22, 2011 at 2:10 am
They are called "client" tools for a reason 🙂
Does the contractor have a real valid reason to go sit before the server and do some work with SSMS and BIDS?
What...
February 22, 2011 at 2:02 am
Yes, if you have a large production environment with over 100+ packages, good luck with opening them with notepad to change the provider, every time you want to deploy them.
You...
February 22, 2011 at 1:14 am
Phil Parkin (2/21/2011)
Koen Verbeeck (2/21/2011)
Phil Parkin (2/21/2011)
Not sure about that trigger idea - nice thought, but won't it just end up doing the same RBAR updates, albeit on the server?
If...
February 22, 2011 at 12:18 am
Phil Parkin (2/21/2011)
You are correct. But bear in mind that the person posting the question was an ultra-newbie and your advice was directed at them, not at an experienced user....
February 22, 2011 at 12:13 am
Viewing 15 posts - 10,081 through 10,095 (of 11,678 total)