pwalter83

Forum Replies Created

Viewing 15 posts - 451 through 465 (of 541 total)

RE: Create trigger to fire SSIS package

Paul,
I am a bit more confused now. The integrations services server uses a port but that is only to start and manage a package controlled within that service. ...

March 25, 2011 at 11:01 am

#1303756
RE: Create trigger to fire SSIS package

Elliott Whitlow (3/24/2011)
Paul,
I'm sorry to be this blunt but the gist of this thread is that this is an a bad practice. If you would like to discuss alternatives that...

March 24, 2011 at 11:07 am

#1303116
RE: Create trigger to fire SSIS package

Hi,
Could someone please help me with the code to trigger an SSIS package when data is inserted in a table on server 1 ?
The SSIS package would then copy...

March 24, 2011 at 3:31 am

#1302840
RE: Create trigger to fire SSIS package

Aren't triggers used by DBAs? 😉
If Service Broker is too far out of your comfort zone, I would go with the solution of Phil Parkin or the one of GSquared.
Actually...

March 23, 2011 at 7:48 am

#1302457
RE: Create trigger to fire SSIS package

Elliott Whitlow (3/16/2011)
I'm going to jump on the bandwagon and say DON'T! There are several ways to handle this and basically all of them are better..
Offering an idea I...

March 22, 2011 at 3:21 am

#1301744
RE: SSRS format getdate

Daniel Bowlin (3/17/2011)
I would probably make 2 parameters, BeginRange and EndRange, (hidden or internal I am not sure what your needs are). Then set the default value for each...

March 18, 2011 at 6:38 am

#1300451
RE: Locked tables clarification

Are you saying the it takes 5 minutes to update the table?
Hi Jeff,
Well, thats a good point which I didnt realize. I thought maybe if the table is just being...

March 16, 2011 at 6:34 am

#1299308
RE: Locked tables clarification

GilaMonster (3/14/2011)
No. It's an isolation level. Have a read through Books Online on Snapshot and Read Committed snapshot and see which would work better for you.
Hi Gail,
Thanks again. atually there...

March 15, 2011 at 3:22 am

#1298728
RE: Locked tables clarification

GilaMonster (3/14/2011)
It may be that the entire table will be locked, it may be that rows or pages will be.
Consider snapshot isolation level (or read committed snapshot). Allows writers to...

March 14, 2011 at 8:39 am

#1298361
RE: Create trigger to insert records into table in different server

Ian Scarlett (3/14/2011)
I would strongly advise against doing this in a trigger.
What would happen if the other server was unavailable? Would you want your original update to fail as...

March 14, 2011 at 5:17 am

#1298258
RE: Create trigger to insert records into table in different server

Hello,
Can anyone please help me in this regard. I don't have any idea about replication and would like to give this a try using triggers.
I have a business requirement...

March 14, 2011 at 4:12 am

#1298248
RE: Trigger error

Ken McKelvey (3/11/2011)
Change the text columns to varchar(MAX)
That resolved it !!! Thanks a lot for your solution !!.

March 11, 2011 at 7:04 am

#1297601
RE: Create trigger to insert records into table in different server

I meant if you could just briefly explain how this can be achieved through replication.

March 11, 2011 at 7:00 am

#1297598
RE: Create trigger to insert records into table in different server

Gianluca Sartori (3/11/2011)
What about replication?
Hi Gianluca,
Thanks for your reply. Could you please explain what you meant by replication as I am very new to SQL ?
Regards,
Paul

March 11, 2011 at 6:58 am

#1297597
RE: Condition in Where clause query

GilaMonster (3/10/2011)
Nothing specific. You could replace all the 1s with 'a' and the 0s with 'b' and get the same result. It's just a trick for evaluations case conditions.
What he's...

March 10, 2011 at 2:25 am

#1296937

Viewing 15 posts - 451 through 465 (of 541 total)