DTS of CSV

#1

Hello,

I have a series of .csv's that I want to DTS to a table on the server. The
situation is that the column names from the csv are imported each time I
execute a DTS.

Is there some way to not import the headings?

Thanks
--
Kenny G

#2

You probably need to on the Flat File Source manager to tick the box
that says "First Row Contains Column Names" (or the like)

Allan

"Kenny G" <KennyG (AT) discussions (DOT) microsoft.com> wrote

Quote:

Hello,

I have a series of .csv's that I want to DTS to a table on the server.
The
situation is that the column names from the csv are imported each time I
execute a DTS.

Is there some way to not import the headings?

Thanks
--
Kenny G

#3

Allen,

I'm new here. Is it in the properties of the source file? I didn't see it.
--
Kenny G

"Allan Mitchell" wrote:

Quote:

You probably need to on the Flat File Source manager to tick the box
that says "First Row Contains Column Names" (or the like)

Allan

"Kenny G" <KennyG (AT) discussions (DOT) microsoft.com> wrote in message
news:3E2B49F6-3FAE-40CC-B01B-F62163122333 (AT) microsoft (DOT) com:

Hello,

I have a series of .csv's that I want to DTS to a table on the server.
The
situation is that the column names from the csv are imported each time I
execute a DTS.

Is there some way to not import the headings?

Thanks
--
Kenny G

#4

After specifying your source file you hit the properties button
underneath the text box with the name of the file within.

"Kenny G" <KennyG (AT) discussions (DOT) microsoft.com> wrote

Quote:

Allen,

I'm new here. Is it in the properties of the source file? I didn't see
it.
--
Kenny G

"Allan Mitchell" wrote:

You probably need to on the Flat File Source manager to tick the box
that says "First Row Contains Column Names" (or the like)

Allan

"Kenny G" <KennyG (AT) discussions (DOT) microsoft.com> wrote in message
news:3E2B49F6-3FAE-40CC-B01B-F62163122333 (AT) microsoft (DOT) com:

Hello,

I have a series of .csv's that I want to DTS to a table on the
server.
The
situation is that the column names from the csv are imported each
time I
execute a DTS.

Is there some way to not import the headings?

Thanks
--
Kenny G

#5

Allen,

Many thanks.

--
Kenny G

"Allan Mitchell" wrote:

Quote:

After specifying your source file you hit the properties button
underneath the text box with the name of the file within.

"Kenny G" <KennyG (AT) discussions (DOT) microsoft.com> wrote in message
news:3D01EAFF-B28B-4142-88E6-52A0FCCCC9A2 (AT) microsoft (DOT) com:

Allen,

I'm new here. Is it in the properties of the source file? I didn't see
it.
--
Kenny G

"Allan Mitchell" wrote:

You probably need to on the Flat File Source manager to tick the box
that says "First Row Contains Column Names" (or the like)

Allan

"Kenny G" <KennyG (AT) discussions (DOT) microsoft.com> wrote in message
news:3E2B49F6-3FAE-40CC-B01B-F62163122333 (AT) microsoft (DOT) com:

Hello,

I have a series of .csv's that I want to DTS to a table on the
server.
The
situation is that the column names from the csv are imported each
time I
execute a DTS.

Is there some way to not import the headings?

Thanks
--
Kenny G

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

DTS of CSV

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

DTS of CSV - 11-03-2005 , 02:50 PM

Re: DTS of CSV - 11-03-2005 , 03:00 PM

Re: DTS of CSV - 11-03-2005 , 03:18 PM

Re: DTS of CSV - 11-03-2005 , 05:28 PM

Re: DTS of CSV - 11-04-2005 , 07:09 AM