November 18, 2005 at 3:10 pm
DTS package in SQL server versus structured storage file:
I experience huge difference in performance between DTS packages traditionally stored in SQL server and when stored as structured storage file. Structured storages files containing exacly the same steps are up to 5 times faster than the same version stored in SQL server.
Is this 'normal'? What possibilities do I have to integrate the packages in de server without this enormous performance loss.
November 18, 2005 at 7:42 pm
How very intersting.
What are the types of tasks within this DTS package?
ActiveX, BulkInsert, Transform Data?
SQL = Scarcely Qualifies as a Language
November 19, 2005 at 3:13 am
The total procedure contains all items but the tranfsformations and update queries are the main items that slow down.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply