> HI Allan,
>
> No i have not changed any options and am using the default as they
> are. Very strange behaviour since it also gives me a success result
> after the step is executed.
>
> Thanks.
>
> "Allan Mitchell" wrote:
>
>> Hello manish,
>>
>> There shouldn't be an inconsistency. I have loaded 17 million rows
>> using the text file driver in SQL Server 7 succesfully. Have you
>> changed any of the default options on the transform data task?
>>
>> Allan
>>
>>> When i try to import a file with 471000 rows of data using Microsoft
>>> text driver to a SQL Server (version 7), DTS only imports about
>>> 416000 rows and give me a success message.
>>>
>>> I tried deleting a few rows of data and inserting a few rows of
>>> data, and also checked the full data set to make sure that there
>>> were no special characters. It is a tab delimited text file.
>>>
>>> When i do a bulk insert, SQL server does insert all the rows into
>>> the server. Can anyone please help me as to what is causing this
>>> inconsistency.
>>>