Friday, February 10, 2012

Can I just import first several rows of Text file to Table using DTS

Hello Group
I want import Text files to database using DTS, but I only want to
import first several Rows because the file size is very big and the
first row contains colomn names, I hope to check the field names first.
Anyone help meI'm not a big DTS guy, you might check the DTS groups, but with BULK INSERT
you can specify WITH options like FIRSTROW and LASTROW.
A
<helloyou8888@.yahoo.ca> wrote in message
news:1149697121.715659.143370@.h76g2000cwa.googlegroups.com...
> Hello Group
> I want import Text files to database using DTS, but I only want to
> import first several Rows because the file size is very big and the
> first row contains colomn names, I hope to check the field names first.
> Anyone help me
>

No comments:

Post a Comment