Search
InstantDoc ID
GO

Browse By: Author | Issue

September 19, 2001 05:19 PM

Truncating Data

Rating: (0)
Richard Waymire
SQL Server Magazine
InstantDoc ID #21896

I built a Data Transformation Services (DTS) package that exports data from a SQL Server 7.0 table to a Microsoft Excel spreadsheet. The package's first run works fine, but subsequent runs just append the data to the spreadsheet instead of replacing the data in the spreadsheet. How can I avoid this problem?

...

...This article is for paid Professional Members only.

Already a Professional Member? Please log in now:

NOT A PROFESSIONAL MEMBER? YOU CHOOSE:

Professional Membership

Monthly

Annual

VIP Membership

Monthly

Annual

Compare Member Benefits

Add a Comment

I use a DROP TABLE `results` (Execute SQL Task) as the first step of the DTS package (where "results" is the name of the sheet that contains the data in the excel spreadsheet). Make sure you set it to the Excel file connection (in my case, connection 2).

David Wood 1/3/2002 12:35:56 PM

You must log on before posting a comment.

Are you a new visitor? Register Here
GOOGLE LINKS
SPONSORED LINKS
FEATURED LINKS

© 2010 Penton Media, Inc.

Windows is a trademark of the Microsoft group of companies. Windows IT Pro is used by Penton Media Inc. under license from owner.