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)  DTS Export DATA to Excel

Author  Topic  kienhow Starting Member 2 Posts Posted - 2008-03-24 : 09:04:32 I am doing a DTS to export data to a excel And i use transfom data task to do it. By Using ActiveXScript to copy the data from database to excel column ======================================= Function Main() If ''DTSSource(''Status'') = ''APROVED'' THEN DTSDestination('Money')= DTSSource(''Money'') DTSDestination('Month')= DTSSource(''Month'') DTSDestination('TotalSaving')= TSSource(''TotalSaving'') ELSE DTSDestination('Money')= DTSSource(''Money'') DTSDestination('Month')= DTSSource(''Month'') END IF I am facing problem want to show the TotalSaving for the else case to another excel file. Pls help to give some idea ////////////////////////////////////// My query in the first page is select * from TblSavingAccount