June 15, 2008 at 2:15 am
Hi SSIS Experts ,
Following are the time taken to complete when executing an SSIS Package in different environment ( s )
1. Command prompt using DTEXEC - 5 seconds 🙂
2. SQLServer Agent job using SSIS Subsystem - 7 seconds 😛
3. SQLServer Agent job using Operating System ( 64 bit DTEXEC ) - 5 min 45 seconds :angry:
4. SQLServer Agent job using xp_cmdshell ( T- Sql ) - 4 min 50 Sec. :crazy:
5. BIDS ( 32 bit env ) - 7 seconds 😀
Note :
1. SSIS Packages are stored in msdb
2. configuration values are stored in user database ( on seperate table ) in same server.
3. SQLServer 2005 SP2,x64 bit 8 dual core processors & 24 GB RAM
4. No other activities are performed during the execution
5. It is applicable to all the SSIS Packages in the environment.
I would really appreciate any pointer you all might have.
Regards
Marimuthu
June 16, 2008 at 5:52 am
I don't see a question.
Use option #2.
June 16, 2008 at 7:28 am
we have scheduled all the packages using SQLServer Agent job of type Operating System ( 64 bit DTEXEC )
Please let me know why it is taking long time compared to other options?
June 16, 2008 at 7:32 am
You should not use CmdExec - why did you?
What options have you specified?
Are you 100% sure you have used the 64bit DTEXEC?
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply