Thanks for the help I was able to fix the problem.

It is working find now. I was able to use DECIMAL(x,2) NULL DEFAULT 0.00,

Thank everyone for your help.

Everything in there in column is numeric

I was able to import the file into excel and the column format is general. The column is a numeric with 2 decimal place.

The source file is flat file.

The Data Conversion within the SSIS package worked.

Thank you

Chris,

That table column fields do match they just don't have the same name. The tables represent some History and some Present. So the Present column tables will have a...

Thanks Lowell for you help it worked like a charm.

Thanks Wayne it work perfect. 😀

Craig, I'm not sure I understand what you are saying when you say if I do the left join on the two tables, I will see a Null's on the...

Ok I have modified the SQL Statement and when I run this statement I am getting 682 record which is correct.

SELECT RM20101.DOCDATE AS bldat, RM20101.POSTDATE, RM20101.DOCNUMBR,...

I received this error msg when I put in that case statement "An expression of non-boolean type specified in a context where a condition is expected, near 'end'."

Thank you very much. It is working like a charm.

why is this statement not working:

select t1.ACTNUMBR_1, t1.ACTNUMBR_4, t1.ACTINDX, t1.CREATDDT

from C1.dbo.AN00100 t1 union all

select t2.ACTNUMBR_1, t2.ACTNUMBR_4, t2.ACTINDX, t2.CREATDDT

from C2.dbo.AN00100 t2 union all

select t3.ACTNUMBR_1, t3.ACTNUMBR_4, t3.ACTINDX, t3.CREATDDT

from C3.dbo.AN00100 t3

WHERE ...

When removing the Where clause this is what I get. The column heading all on one row.

ACTNUMBR_1 ACTNUMBR_4ACTINDXCREATDDT

103 6140002909612/28/2006

103 999900239141/17/2002

106...