MS SQL Server DTS Import 1

[sa0309]

I'm attempting to import a text file that can contain negative numbers into a SQL Server 2000 table via a DTS package.

My field is defined as numeric(9,2). The source data is formatted 123.99- Is there a way load it with the negative sign being at the end.

I know the load works when the negative sign is in front, -123.99. However; I have little control on the formatting because my source file is from an outside vendor.

Any help is appreciated.

 

[MDXer]

only thing I can think of is a script to move the - to the front.

 

[sa0309]

MDXer - kind of what I was thinking also.

Thanks

 

[rasETL]

I am probably too late on this response, but...

When I load data via DTS into a SQL table, I load it into all CHAR columns. This becomes my staging table, and I can guarantee that all data gets loaded, valid or not. Using this approach, you could load the trailing sign into its own column and use it to determine the numeric load.

Hope that helps.