<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>
Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Write for us
<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>
Recent Posts
Recent Posts
Popular Topics
Popular Topics
Home
Search
Members
Calendar
Who's On
Home
»
Data Warehousing
»
Integration Services
»
Calling SSIS Package in a trigger
Calling SSIS Package in a trigger
Rate Topic
Display Mode
Topic Options
Author
Message
mpradeep23
mpradeep23
Posted Thursday, January 10, 2013 12:03 AM
SSC Rookie
Group: General Forum Members
Last Login: Today @ 12:11 AM
Points: 45,
Visits: 170
Hi
i trying call SSIS Package from a Trigger is there any perforamnce issue to the database
thanks in advance
with best regards
pradeep
Post #1405226
Phil Parkin
Phil Parkin
Posted Thursday, January 10, 2013 1:43 AM
SSCarpal Tunnel
Group: General Forum Members
Last Login: Today @ 9:29 AM
Points: 4,240,
Visits: 9,487
mpradeep23 (1/10/2013)
Hi
i trying call SSIS Package from a Trigger is there any perforamnce issue to the database
thanks in advance
with best regards
pradeep
Based on the limited information provided, my best answer is 'probably' and my advice would be to look for an alternative solution to whatever requirement you have been given.
____________________________________________________________________________________________
Help us to help you. For better, quicker and more focused answers to your questions, consider following the advice in this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
If you are asking for help and your post does not contain a question, you should expect responses which do not contain any answers. Put a question mark in there somewhere - it's not rocket science.
Post #1405259
mpradeep23
mpradeep23
Posted Thursday, January 10, 2013 1:54 AM
SSC Rookie
Group: General Forum Members
Last Login: Today @ 12:11 AM
Points: 45,
Visits: 170
i have two tables in two sql servers i need two move data from one table to other on insert /update i had written a ssis package for this so when thier is update in one table then i need update it in to other table so for that can i call SSIS Package in Trigger so that will copy the data from source to destination
thanks
pradeep
Post #1405271
Phil Parkin
Phil Parkin
Posted Thursday, January 10, 2013 2:28 AM
SSCarpal Tunnel
Group: General Forum Members
Last Login: Today @ 9:29 AM
Points: 4,240,
Visits: 9,487
mpradeep23 (1/10/2013)
i have two tables in two sql servers i need two move data from one table to other on insert /update i had written a ssis package for this so when thier is update in one table then i need update it in to other table so for that can i call SSIS Package in Trigger so that will copy the data from source to destination
thanks
pradeep
Imagine a process on server 1 which has been written by a C# guy who knows nothing about set-based programming. He is inserting 10,000 rows one at a time in a loop in his program. Do you really want a trigger to execute an SSIS package 10,000 times in just a few seconds?
Far better to run the package every few minutes & pick up any changes then. Or use CDC if you have a high enough version of SQL Server.
____________________________________________________________________________________________
Help us to help you. For better, quicker and more focused answers to your questions, consider following the advice in this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
If you are asking for help and your post does not contain a question, you should expect responses which do not contain any answers. Put a question mark in there somewhere - it's not rocket science.
Post #1405284
mpradeep23
mpradeep23
Posted Thursday, January 10, 2013 4:17 AM
SSC Rookie
Group: General Forum Members
Last Login: Today @ 12:11 AM
Points: 45,
Visits: 170
CDC works if tables are in different instances of sql sever?
thank s
pradeep
Post #1405333
anthony.green
anthony.green
Posted Thursday, January 10, 2013 4:31 AM
SSCertifiable
Group: General Forum Members
Last Login: Friday, April 12, 2013 3:51 AM
Points: 5,075,
Visits: 4,831
What about setting up replication for the table(s) in question?
Want an answer fast? Try here
How to post data/code for the best help - Jeff Moden
Need a string splitter, try this - Jeff Moden
How to post performance problems - Gail Shaw
CrossTabs-Part1
&
Part2 - Jeff Moden
SQL Server Backup, Integrity Check, and Index and Statistics Maintenance - Ola Hallengren
Managing Transaction Logs - Gail Shaw
Troubleshooting SQL Server: A Guide for the Accidental DBA - Jonathan Kehayias and Ted Krueger
Post #1405339
opc.three
opc.three
Posted Thursday, January 10, 2013 6:39 AM
SSCertifiable
Group: General Forum Members
Last Login: Today @ 2:56 PM
Points: 6,718,
Visits: 11,753
mpradeep23 (1/10/2013)
CDC works if tables are in different instances of sql sever?
thank s
pradeep
Sure, CDC is an option but if you do not need a record of all historical data changes then it is likely overkill and still will not deliver real-time data to the downstream system. With CDC changes are queued on the source system. You'll still need a process to take those changes and push them to a downstream system which is likely going to best implemented as an SSIS package.
Most types of SQL Server Replication require no development, only configuration. Have you looked into? I think you would be interested in Transactional Replication with a Push Subscription from your upstream system to your downstream system which requires no development and delivers as close to real-time data on the subscriber as possible.
__________________________________________________________________________________________________
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
Believe you can and you're halfway there.
--Theodore Roosevelt
Everything Should Be Made as Simple as Possible, But Not Simpler
--Albert Einstein
The significant problems we face cannot be solved at the same level of thinking we were at when we created them.
--Albert Einstein
1 apple is not exactly 1/8 of 8 apples. Because there are no absolutely identical apples.
--Giordy
Post #1405392
Bruce W Cassidy
Bruce W Cassidy
Posted Friday, January 11, 2013 12:20 PM
SSC Eights!
Group: General Forum Members
Last Login: Friday, March 22, 2013 11:49 AM
Points: 945,
Visits: 998
If all you are doing is copying the data from one instance to another, then I would agree that replication is probably a far better solution. It sounds to me as if you are trying to develop something that is already built in.
Post #1406222
« Prev Topic
|
Next Topic »
Permissions
You
cannot
post new topics.
You
cannot
post topic replies.
You
cannot
post new polls.
You
cannot
post replies to polls.
You
cannot
edit your own topics.
You
cannot
delete your own topics.
You
cannot
edit other topics.
You
cannot
delete other topics.
You
cannot
edit your own posts.
You
cannot
edit other posts.
You
cannot
delete your own posts.
You
cannot
delete other posts.
You
cannot
post events.
You
cannot
edit your own events.
You
cannot
edit other events.
You
cannot
delete your own events.
You
cannot
delete other events.
You
cannot
send private messages.
You
cannot
send emails.
You
may
read topics.
You
cannot
rate topics.
You
cannot
vote within polls.
You
cannot
upload attachments.
You
may
download attachments.
You
cannot
post HTML code.
You
cannot
edit HTML code.
You
cannot
post IFCode.
You
cannot
post JavaScript.
You
cannot
post EmotIcons.
You
cannot
post or upload images.
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
