2.5 hours too much for a file of size 26MB ...I've been importing files with 30MB+ in just 2-3 minutes. I mainly use Transfer Data and Bulk Insert tasks in the DTS which is quite fast. Try using these...
I've imported the file as a text file (as it's in .csv format) and created a DTS package again. It now seems to work a treat and imports the large files in no time at all.
Many thanks for your advice.
Cheers Mark 🙂
Viewing 2 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply