Import empty string

#1

Hi,

I am trying to create a package which imports a fixed width ascii file to a
table. However, it is failing with this error - 'Script encountered an
invalid data value for 'fieldname' destination column'. The problem is where
the source has an empty string. How can I get around this please?

ps the table has allow nulls

Tom

#2

You could read the line in as 1 string and then parse that into your
destination

--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.Konesans.com

"Tom Swanick" <tom.swanick (AT) activant (DOT) com> wrote

Quote:

Hi,

I am trying to create a package which imports a fixed width ascii file to
a
table. However, it is failing with this error - 'Script encountered an
invalid data value for 'fieldname' destination column'. The problem is
where
the source has an empty string. How can I get around this please?

ps the table has allow nulls

Tom

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

Import empty string

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

Import empty string - 10-11-2004 , 02:57 AM

Re: Import empty string - 10-11-2004 , 12:38 PM