HI All, My Extration Program is working fine. I am using DTS through VB and transfering data from one database to another. But now I need to know how many rows transfer from each table from scource to destination is there any property of DTS object in VB? Thanx in Advance SQL is love
Don't know but may search underhttp://www.sqldts.com website for any pointers. _________ Satya SKJ Moderator SQL-Server-Performance.Com
Another link to look: http://sqldev.net/dts/KnowledgeBaseArticles.htm Luis Martin ...Thus mathematics may be defined as the subject in which we never know what we are talking about, nor whether what we are saying is true. Bertrand Russell