February 23, 2015 at 5:07 pm
Hi All,
Bringing to life this old topic:
http://www.sqlservercentral.com/Forums/Topic1307523-364-1.aspx
I unchecked {Check for publisher revocation certificate} option in Internet Options, but time is bigger when I execute dts package using DTEXEC than BIDS.
Scenario:
Windows 2012 Standard 64bit.
Microsoft SQL Server Enterprise Edition (64-bit) 2008 SP4
DTS Package is design to upload an CSV file into SQL Server Table. I'm using Flat File Source and SQL Server Destination.
If I run dts package using DTEXEC
Microsoft (R) SQL Server Execute Package Utility
Version 10.50.4000.0 for 64-bit
Copyright (C) Microsoft Corporation 2010. All rights reserved.
Started: 5:29:23 PM
DTExec: The package execution returned DTSER_FAILURE (1).
Started: 5:29:23 PM
Finished: 5:29:25 PM
Elapsed: 2.558 seconds
If I run dts package using BIDS
Start, 3:11:06 PM
Finished, 3:11:07 PM
Elapsed time: 00:00:01.263
If I run dts package using SQL Job
Start, 3:20:10 PM
Finished, 3:20:14 PM
Elapsed time: 00:00:04
Any help will be appreciated.
Regards
February 24, 2015 at 3:12 am
Why does the package fail?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
February 24, 2015 at 8:08 am
Hi,
Thank you for your question, basically package don't fail, issue is related with duration, when I execute from BIDS is faster than execute using DTEXEC or Job.
Regards
February 24, 2015 at 8:23 am
A sample size of 1 run per setting is pretty meaningless.
February 24, 2015 at 9:41 am
Hi,
Thank you for your answer. I already ran package for ten times and results are the same BIDS is faster than DTEXEC.
Regards
Rodrigo
February 25, 2015 at 12:32 am
What if you use an OLE DB Destination with Fast Load instead of the SQL Server Destination?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply