I have a very weird data transformation problem..
I have been using a DTS to transform a text file into a table. The Text file usually has about 700K records. It seems to be doing fine everyday, except today when it transforms only 345K records.
However, if I do repeat this process manually a few times, out of 5 tries, I will manage to transform a 100% at least once.
Anyone has any idea, what is going on? I want to try and check the text file but it is too huge for any application to open it.
Please advise. Thanks.
-- gyfu --
Crystal Ver 10
Microsoft SQL
I have been using a DTS to transform a text file into a table. The Text file usually has about 700K records. It seems to be doing fine everyday, except today when it transforms only 345K records.
However, if I do repeat this process manually a few times, out of 5 tries, I will manage to transform a 100% at least once.
Anyone has any idea, what is going on? I want to try and check the text file but it is too huge for any application to open it.
Please advise. Thanks.
-- gyfu --
Crystal Ver 10
Microsoft SQL