Wrox Programmer Forums
Go Back   Wrox Programmer Forums > SQL Server > SQL Server DTS
| Search | Today's Posts | Mark Forums Read
SQL Server DTS Discussion specific to Data Transformation Service with SQL Server. General SQL Server discussions should use the general SQL Server forum. Readers of the book Professional SQL Server 2000 DTS with questions specific to that book should post in that book forum.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the SQL Server DTS section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old September 23rd, 2004, 12:59 PM
Registered User
 
Join Date: Sep 2004
Location: geneve, , Switzerland.
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default import excel file and stop at first empty row

Very new to DTS, I'm trying to import an excel file in a table.
My problem is that this daily excel file has a various length thus I don't want to specify the number of rows. Unfortunately if I leave 0 in the "Last row" of the "option" tab, DTS charges thousands of rows (when I only have around 300 today)
I also get an error because one of the column is a non-nullable key, because it imports empty rows...

How to tell DTS to stop at the first empty row ?
 
Old September 23rd, 2004, 02:26 PM
Friend of Wrox
 
Join Date: Jun 2003
Location: Harrisburg, PA, USA.
Posts: 1,998
Thanks: 0
Thanked 3 Times in 3 Posts
Default

Hey,

There's got to be some text stuff in those cells that makes DTS think there's data there. How is the Excel file created? You could follow up with a query that deletes empty records.

Brian
 
Old September 24th, 2004, 04:16 AM
Registered User
 
Join Date: Sep 2004
Location: geneve, , Switzerland.
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Thank you very much Brian
There was indeed some invisible excel formatting rubish




Similar Threads
Thread Thread Starter Forum Replies Last Post
Import from Excel sheet to a text file zone Excel VBA 1 July 26th, 2007 10:34 AM
How to import a text file w/t changing row order lxj034000 SQL Server 2000 1 July 12th, 2007 07:04 AM
Import & Export Excel File prasanta2expert ASP.NET 1.0 and 1.1 Basics 5 March 5th, 2007 09:28 AM
Import an excel file into access arjunvs Access VBA 1 September 15th, 2004 07:21 PM
How to import Excel file to vc++ editor lokanadham Beginning VB 6 0 September 15th, 2004 05:35 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.