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 |
|
NJDba
Starting Member
31 Posts |
 Posted - 2007-11-19 : 17:44:37
|
| Since the ActiveX is not supported in SQL Server 2005, I am rewriting the SSIS package which includes ActiveX. But I found out the new SSIS package takes more spaces and takes longer time running then before? Is that normal?Thanks. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-11-19 : 17:45:55
|
| We don't have enough information to answer your question. What does "more spaces" mean?Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
 |
|
|
NJDba
Starting Member
31 Posts |
Posted - 2007-11-19 : 17:59:28
|
| I migrated the DTS from 2000, and the migrated SSIS which includes ActiveX script is 11KB, takes 00:00.125 running. I rewrote the SSIS using some new features provided in BIDS, and the new package is 50KB, takes 00:00:6.016 running. Is that normal or maybe the efficiency of my code?thanks. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-11-19 : 23:28:53
|
| Hard to say without details. |
|
|
|
|
|
|
DTS vs. SSIS