Import text files into table

#1

When importing multiple text files into a SQL server table
by DTS Transform Data Task, can DTS package detect the
damaged text files (such as no charaters, or wrong format)
automatically? How to do that?

Thanks in advance.

-Don

#2

It will error !. You will need to pre scrub the files

--
--

Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org

"Don Walter" <anonymous (AT) discussions (DOT) microsoft.com> wrote

Quote:

When importing multiple text files into a SQL server table
by DTS Transform Data Task, can DTS package detect the
damaged text files (such as no charaters, or wrong format)
automatically? How to do that?

Thanks in advance.

-Don

#3

Thanks, Allan.
But how to pre scrub the files?
Can you give me some suggestion on that skill?

-Don

Quote:

-----Original Message-----
It will error !. You will need to pre scrub the files

--
--

Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org

"Don Walter" <anonymous (AT) discussions (DOT) microsoft.com> wrote
in message
news:02cb01c3aee3$e07885b0$a501280a (AT) phx (DOT) gbl...
When importing multiple text files into a SQL server
table
by DTS Transform Data Task, can DTS package detect the
damaged text files (such as no charaters, or wrong
format)
automatically? How to do that?

Thanks in advance.

-Don

.

#4

Darren wrote a padding task although I cannot find it at the moment.

Use VB is my answer to scrub the files. You can either call out to an
external exe to do this or write a custom task to do the scrubbing.

--
--

Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org

"Don" <anonymous (AT) discussions (DOT) microsoft.com> wrote

Quote:

Thanks, Allan.
But how to pre scrub the files?
Can you give me some suggestion on that skill?

-Don

-----Original Message-----
It will error !. You will need to pre scrub the files

--
--

Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org

"Don Walter" <anonymous (AT) discussions (DOT) microsoft.com> wrote
in message
news:02cb01c3aee3$e07885b0$a501280a (AT) phx (DOT) gbl...
When importing multiple text files into a SQL server
table
by DTS Transform Data Task, can DTS package detect the
damaged text files (such as no charaters, or wrong
format)
automatically? How to do that?

Thanks in advance.

-Don

.

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

Import text files into table

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

Import text files into table - 11-19-2003 , 03:27 PM

Re: Import text files into table - 11-19-2003 , 04:09 PM

Re: Import text files into table - 11-19-2003 , 04:55 PM

Re: Import text files into table - 11-20-2003 , 12:27 AM