SQL 2008 (AX Dynamics) data export taking too long

HKFuey
HKFuey used Ask the Experts™
on
I'm trying to export a View as a Flat text File. The view has 6 months of transactions and executes in 5 seconds.
I created an export data DTS package to export this data to text and it is taking an age, the data file is stored on the same server.

Anyone know why this is taking so long?
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Raja Jegan RSQL Server DBA & Architect, EE Solution Guide
Awarded 2009
Distinguished Expert 2018

Commented:
>> I created an export data DTS package to export this data to text and it is taking an age

is it completing successfully after taking a lot of time, if so what is the maximum time it took to export the flat file via DTS package.
Kindly double check whether the batch size is set to very small value in the DTS package which will take long time to export..

Author

Commented:
25,0000 records took 4 hours the resulting text file was 7 Mb. Not sure where to check batch size?
Raja Jegan RSQL Server DBA & Architect, EE Solution Guide
Awarded 2009
Distinguished Expert 2018

Commented:
Check the properties of the Source Connection manager in your DTS package..
Commented:
I changed the SQL view, the table joins must have been wrong. Working perfectly now.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial