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 |
|
paulrap99
Starting Member
1 Post |
 Posted - 2011-05-02 : 11:25:12
|
| Hi,My company is in the process of rebuilding our data warehouse. We hired a DW architect to help us design the new overall solution. The DW guy wants to use SSIS packages over SPs. All my developers think the idea is stupid as they hate SSIS for troubleshooting. I need some concrete reasons to tell this guy why a mix of both is the best approach. We currently have 250 SPs and 700 table’s in our existing solution. He wants to completely move away from SPs and go with all SSIS packages. Can we start a thread for pros and cons to this methodology?Thanks. |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2011-05-02 : 12:19:18
|
| What was the architect's reasoning for using SSIS? Make him spell out the advantages and demonstrate them, compared to the stored procedure approach. By the same token, your dev team should list their objections to SSIS with documented, demonstrable examples, not just gut feeling or "that's how we're used to doing it".BTW there's no reason you can't use stored procedures as data sources in SSIS. It's certainly not an all-or-nothing prospect. |
 |
|
|
|
|
|
SSIS vs Stored Procedures