Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
ds9
Starting Member
38 Posts |
 Posted - 2007-03-09 : 09:38:07
|
| Hi everybodyI'm still trying to learn the advantage of having stored procedures. I have a DTS that uses a Transform Data Task to append the result of a view into a table. All operations are done locally in the server.Do I have any advantage if I write a stored procedure to insert the view into the table, and then call the stored procedure in the DTS, in stead of using the Transform Data Task ?Thanks in advance for your thoughtsds9 |
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2007-03-09 : 10:02:21
|
| if it's local (same server), I would do it in a stored procedure then just schedule the transferI use dts if the source and target objects are different like file and table or objects on different server instancemainly because I think of the maintenance of the setup and recovery should the source or target fails... my motto is to minimize point of failuresbut i'm not a guru, others will probably have a better opinion--------------------keeping it simple... |
 |
|
|
|
|
|
Transform Data Task vs Stored Procedure