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 |
|
nyy0723
Starting Member
4 Posts |
 Posted - 2006-08-14 : 04:00:35
|
| Dear All,MY enviroment is on SQL SERVER 2005.I deploy dtsx to MSDB and execute as bellow,dtexec /DTS MSDB\PKGNAMEThen I change to deploy dtsx to File system and execute as bellow, dtexec /f "dtsx file directory/package name"It also can work, but the performance is bad.Is anyone know how to solve this problem??Thanks a lotRegardsnyy |
|
|
Wanderer
Master Smack Fu Yak Hacker
1168 Posts |
Posted - 2006-08-14 : 10:13:03
|
| are you saying that the performance in the SQL deployed package is different to a file system deployed ssis package? If so, what is the difference - i.e what different times do you get for the different methods of executions.Is there any other difference between the two - for example validation disabled on one of them, or .Net scripts being set to 'precompilebinary'=ture?*##* *##* *##* *##* Chaos, Disorder and Panic ... my work is done here! |
 |
|
|
|
|
|
DTEXEC FILE SYSTEM AND MSDB PERFORMACE