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 |
|
pravin14u
Posting Yak Master
246 Posts |
 Posted - 2007-01-05 : 00:42:45
|
| Hi All,Our client is a multinational Cigar company and we have been building SSIS packages for them for extraction of data into data marts. We tried to do all the tasks using T-SQL procedures also and tried comparing the performance of procedures and SSIS packages. We found out that procedures are better than SSIS packages in performance(Time taken). Why is this so?We expected the SSIS packages to be much quicker but it was not the case...Thanks,Prakash.P |
|
|
snSQL
Master Smack Fu Yak Hacker
1837 Posts |
Posted - 2007-01-05 : 12:35:24
|
| Why did you expect SSIS to be much quicker? (SSIS is for integrating and transforming data, performance is good but isn't its number one goal) How much better are the stored procedures? |
 |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2007-01-05 : 13:27:15
|
it depends on the task.what tasks did you run.Go with the flow & have fun! Else fight the flow  blog thingie: http://weblogs.sqlteam.com/mladenp |
|
|
|
|
|
|
SSIS Performance