Hello,

I have created a dts package and executing from asp page.
this package takes the textfile ( path will be supplied through global
variable) and dumps the data in to a temporary table.

When i execute asp page, every time i get a different status,
some times it says
"Step [DTSStep_DTSDataPumpTask_1] " step failed
some times it says succeeded.

I dont know , why it's behaviour so peculiar.

Could any body help me to figure out the issue.

Thanks in advance
Murali

Note:
OS and Database details
( O/S Windows 2000 ;Database is SQL Server 2000 ( Developer Edition) (with
all latest patches ) )