Hi,

I have a tab delimited file I'm trying to import into sql server. My table doesn't allow null values. My problem is, the source text-file looks at two tabs together and treats it as a null value. I'd rather not have this if possible, but have an empty string. Is there any way to set DTS so it interprets <tab><tab> as an empty string? I realize I can write an activex script to check for null values during the transformation, but that seems like that shouldn't have to be done.

Thanks for any help,
--Michael

Problem is without getting into Active Script Transforms then the Text File
driver is not very flexible.

I _ALWAYS_ import to a staging table before moving to my real table and then
use TSQL to do the move into the real table.

The speed of BULK INSERT is favourable and I have never been constrained by
the extra step

--
--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.konesans.com - Consultancy from the people who know


"Raterus" <moc.liamtoh (AT) suretar (DOT) reverse> wrote

Hi,

I have a tab delimited file I'm trying to import into sql server. My table
doesn't allow null values. My problem is, the source text-file looks at two
tabs together and treats it as a null value. I'd rather not have this if
possible, but have an empty string. Is there any way to set DTS so it
interprets <tab><tab> as an empty string? I realize I can write an activex
script to check for null values during the transformation, but that seems
like that shouldn't have to be done.

Thanks for any help,
--Michael

thanks!

"Allan Mitchell" <allan (AT) no-spam (DOT) sqldts.com> wrote