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
 Transact-SQL (2000)
 Tranfer data

Author  Topic 

PatDeV
Posting Yak Master

197 Posts

Posted - 2005-11-07 : 17:11:34
Hi,


I have DTS package which transfer the Text file to excel but it is not overwirting it. appends the data instead. How can i make to overwirte the data!!

Thanks

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2005-11-08 : 01:47:34
You need to Delete Excel data or Delete the Excel file and recreate it
Refer this
www.sqldts.com


Madhivanan

Failing to plan is Planning to fail
Go to Top of Page
   

- Advertisement -