SSIS runtime de-round Numbers

Issue: I have very strange issue with package that transofm data from excel file to text file, the issue that if there's a value in the excel with decimal point ends with .12345 it transformed to text file to .123449999999998. actuall all the sequence numbers less than or equal 5 drop the same issue.
for examble if we have the below value in the excel:
22.12345 it transfomed to 22.123449999999998 in the text file, i put i dataviewer after the excel data source and everything seems alright, the data type of the source columns are double precision.

Cause: Unknown, i communicated with one developer from SSIS team and he tried to troupleshoot the problem with me, but the cause is still unknows.

Wrok Around solution:

put a data conversion before the destination, and convert the type to decimal with only 5 scale.

Backup DB error

Problem: i create a deployment project for a windows application, this setup will install SQL Server express edition before installing the application, after installing the application and when the user trying to backup the DB using the application it gave me the below error
"Cannot open backup device 'C:\backupname.bak'. Operating system error 5(error not found).BACKUP DATABASE is terminating abnormally." and the only location i can create the backup is "C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Backup".

Cause: becaue the SQL Server Express Service run under account "Local Syetm Network".

Resolution:

1. Go to "My Computer" ==> "Control Panel" ==> "Administrative Tools".

2. Open "Services".

3. Locate Service with name "SQL Server (SQLEXPRESS)" and Open it.

4. Choose "Log On" tab.

5. then select "Local System Account".

6. Press "OK".

7. Right Click on the service.

8. Choose Restart.

Created By
Ahmed Abdel Moneim