I am importing data from a textfile of 1,5 GB to my Sql-server and I use activeX for the transformation. I need ActiveX script because I have to change some formats etc.
But, I think it is very slow and I want it to speed up.
Do you have some hints to speed up the transformation?
Thx for the advice!