How can I import text data from IBM DBI file with leading zeros? Once this
data is imported into SQL, datatype will not convert from char to money,
maybe because of the hyphen that represents a negative number.

example of data:

Payment remit date patient name
000000-1247 09/08/03 Jane Doe
0000001247 09/08/03 Jane Doe

I need to delete the zeros in the DTS process so that it looks like this:

Payment remit date patient name
($12.47) 09/08/03 Jane Doe
$12.47 09/08/03 Jane Doe

Can anyone help me with this problem?

So what you do is either

1. Import the file to a staging table AS IS and then use TSQL to only grab
the part of the field that you require
2. You use an Active Script transform to do this.

--

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


"DTS Deleting Leading Zero's" <DTS Deleting Leading Zero's
@discussions.microsoft.com> wrote