Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2000 Forums  Import/Export (DTS) and Replication (2000)   Writing errors / status Information of DTS Packa

Author  Topic  leninch Starting Member 1 Post Posted - 2005-03-03 : 22:37:36 Iam new bee in sql server 2000 . I Created a new Package and have written couple of Data Driven Query Tasks which is actually inserting/updating rows into the tables. I have a lookup function and iam checking that in actives script. i need to write error logs like if the taks fails(Data Driven Query Task) i have to record them in a text file and is the task is fine even then i have to record a log describing 1) Status :: success or failure 2) Number of records updated 3) Reason for failure if status is success.. I can create a text filke using CreateTextFile function in ActiveX Script....An i can write some matter into it... But i couldnt find a function which will tell me the number of rows inserted or updated...and i dont know the function which will give me the status of the row(whether updated or inserted) or even the total number of rows inserted.... Anyone can suggest the functions i have to use would be better .. Regards leni