rounding in ssis--derived?
I am moving the data from ORACLE to text files/SQL table
ORACLE
SQL/Text files-output
I want to keep the original Oracle 1 decimal place format. How can I accomplish this via SSIS.
What SSIS tool can I use on the usage column. derived? if so how?
ASKER
Data from Oracle via ssis package ---Oracle source
yes selecting data based on a query into an output file -Text file or SQL table
SQL is adding a bunch of decimal points. I want to round to 1 decimal point
When I run the same query in SQlplus..I get the desired output
yes selecting data based on a query into an output file -Text file or SQL table
SQL is adding a bunch of decimal points. I want to round to 1 decimal point
When I run the same query in SQlplus..I get the desired output
You'll get, what you ask for. You need to use DECIMAL or NUMERIC math for your desired result. This may involve explicit casting due to the involved math and data types.
ASKER
ste5an..I do not understand your input
Can I can get inputs form others please. It looks like SSIS is doing the extra decimal places. I import sample data into SQL and it looks good. I have to use SSIS because I have to loop through the data and output text files for each day
Can I can get inputs form others please. It looks like SSIS is doing the extra decimal places. I import sample data into SQL and it looks good. I have to use SSIS because I have to loop through the data and output text files for each day
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I indicated the issue and looking for help. Can 't figure it out that is why I consulted experts
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
1. 'exporting' data from Oracle using sql*plus to text
2. importing the text file (csv) into SQL Server using SSIS?
When u import into SQL Server the format changes?