Re: import excel data error

From: Allan Mitchell (allan_at_no-spam.sqldts.com)
Date: 03/24/04 

Date: Wed, 24 Mar 2004 13:02:20 -0000

What will be happening is that although it looks empty to you it won't be to
the driver. I generally delete that row from the ***. 

-- 
----------------------------
Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org
"Victor.Liang" <victor.liang@timogen.com> wrote in message
news:%231QpqTYEEHA.240@tk2msftngp13.phx.gbl...
> Hi all experts,
>
>      I am importing data from excel file,which contain  only two line
> The following is excel file format:
>
>  ID     NAME    ADDRESS
>  1      FRANK   USA
>  2      BUSH    JAPAN
>
> I only copy the two line data into oracle "person"table which contain
> the same column as the excel file.
>
> When I run this transform task, and after DTS have readed two lines data
,it
> seem that DTS will continue to read nexe line of data .
> therefore, A error occur.
>
> How can I let  DTS not to continue to read empty line ?
>
>
> thanks in advance!
>
>
> Victor
>
>
Loading